多选题

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?()

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

正确答案

来源:www.examk.com

答案解析

相似试题
  • 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 Certkiller .com. 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?()

    多选题查看答案