多选题

You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command()

AThe tablespace would require recovery to go back online.

BA checkpoint is taken on all data files that are associated with the SALES tablespace.

CThe sessions that subsequently try to access the objects in the SALES tablespace receive an error

DThe new status of the SALES tablespace is recorded in the control file when the database instance isclosed

正确答案

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

    单选题查看答案