多項(xiàng)選擇題

You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）

A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual

你可能感興趣的試題

單項(xiàng)選擇題

You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）

A.All the extents will be of the same size.
B.Bitmap will be used to record free and allocated extents.
C.Free extents will be managed by the data dictionary tables.
D.The tablespace will be system managed and the users cannot specify the extent size.

單項(xiàng)選擇題

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A.renaming the control files
B.dropping a user in your database
C.enabling or disabling redo log archiving
D.dropping a tablespace in your database
E.re-creating the control files， after you lost all the control files in your database

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）

你可能感興趣的試題

You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）