单选题

You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()

AThe rows stay in the table only until session termination.

BThe rows stay in the table only until the next transaction starts on the table.

CThe rows are visible to all current sessions after the transaction is committed.

DThe rows stay available for subsequent sessions after the transaction is committed

正确答案

来源: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?()

    单选题查看答案