You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
ASet the UNDO_RETENTION parameter to AUTO.
BCreate an initial undo segment in undotablespace.
CSet the UNDO_RETENTION parameter to 900 or more
DSet the initialization parameter UNDO_MANAGEMENT to AUTO
ESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
正确答案
答案解析
相似试题
(单选题)
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()
(多选题)
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
(多选题)
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
(单选题)
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
(单选题)
You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this?()
(多选题)
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
(多选题)
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
(单选题)
You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()
(多选题)
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()