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

You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session:   ALTER SESSION ENABLE RESUMABLE;   Which command could you issue to enable the resumable space allocation feature at the session level?()  

A ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5;

B ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5;

C ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300;

D ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300;

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this?()

    答案解析

  • (单选题)

    You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas?()

    答案解析

  • (单选题)

    You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA table space is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2.  What is the correct sequence RMAN commands to restore and recover the data file?()

    答案解析

  • (单选题)

    View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query, you find that the first two updates are not listed. What could be the reason?() 

    答案解析

  • (单选题)

    You work as a database administrator for Certkiller .com. 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 Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this?()

    答案解析

  • (单选题)

    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()

    答案解析

  • (单选题)

    You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement:   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;   What will be the result of executing this statement?()

    答案解析

  • (多选题)

    During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery.  Which view or views would you use to determine this information?() 

    答案解析

快考试在线搜题