单选题

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

    单选题查看答案