多项选择题
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
相关考题
-
单项选择题
Youspecifiedextentmanagementaslocalforatablespace.Howwillitaffectspacemanagementinthetablespace？（）
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. -
单项选择题
YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate？（）
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 -
单项选择题
When you try to open your database， you receive the following error： ORA-00205： error in identifying controlfile Where would you find the details required to resolve this error？（）
A.audit trail
B.alert log file
C.user trace file
D.online trace file
E.background trace file
F.operating system event viewer
