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

You execute the following command to enable a session in resumable mode:  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;  What is the impact of a timeout on the statements being suspended?() 

AThe statements remain suspended for at least 60 seconds.

BThe statements are suspended for 60 seconds and then they are executed.

CThe suspended statements error out if the problem is not rectified within 60 seconds.

DThe statements are automatically suspended 60 seconds after an error is received, and then attempt toexecute normally again.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You executed the following command in Recovery Manager (RMAN):  RMAN> RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()

    答案解析

  • (多选题)

    You executed the following commands to find the location of the alert log file: Where is the alert log file stored()

    答案解析

  • (单选题)

    You executed the following command in Recovery Manager (RMAN):  RMAN> RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?() 

    答案解析

  • (单选题)

    You execute this command in MOUNT mode: ALTER DATABASE ARCHIVELOG;  Where is the information that the database is now in ARCHIVELOG mode stored?()

    答案解析

  • (多选题)

    When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics.  Which two statements describe the implications of this?()

    答案解析

  • (单选题)

    Before a Flashback Table operation,you execute the following command:   ALTER TABLE employees ENABLE ROW MOVEMENT;   Why would you need this to be executed?()  

    答案解析

  • (单选题)

    You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()

    答案解析

  • (单选题)

    You executed the following code:   BACKUP VALIDATE DATABASE;   BLOCKRECOVER CORRUPTION LIST;  What will be the result of executing the above code?()  

    答案解析

  • (单选题)

    You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()

    答案解析

  • (单选题)

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

    答案解析

快考试在线搜题