首页计算机考试Oracle认证
(多选题)

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

Aguarantee undo retention

Badd one more redo log group

Csize the redo log files appropriately

Dsize the UNDO tablespace appropriately

Esize the SYSTEM tablespace appropriately

Fconfigure an appropriate undo retention interval

Gchange automatic undo management to manual

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

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

    答案解析

  • (单选题)

    Which feature is enabled when you start a WebLogic server with the ¨CDserverType=wlx option?()

    答案解析

  • (多选题)

    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 have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()

    答案解析

  • (单选题)

    You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()

    答案解析

  • (单选题)

    You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error:  ORA-01081: cannot start - already running ORACLE - shut it down first  Which environmental variable would you set before starting up the PAYDB database to overcome this error?()

    答案解析

  • (单选题)

    In which situation are you NOT required to perform an incomplete recovery?()

    答案解析

  • (单选题)

    You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?()

    答案解析

  • (单选题)

    You want the size of the tablespace to increase when it is full. Which option would you use?()

    答案解析

快考试在线搜题