单选题

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()

AThe data in the segment will be compacted but the high water mark will not be adjusted 

BThe EMPLOYEES table will be changed to read-only mode during the shrink operation 

CThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over

DThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 

EData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation

正确答案

来源:www.examk.com

答案解析

相似试题
  • Why would you execute the report obsolete command?()  

    单选题查看答案

  • After the recovery is complete, which command should you execute?()

    单选题查看答案

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

    单选题查看答案

  • Which operation requires that you create an auxiliary instance manually before executing the operation?()

    多选题查看答案

  • You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()

    单选题查看答案

  • You want to create a temporary table while executing a procedure in a form. Which statement is true?()

    单选题查看答案

  • You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()

    单选题查看答案

  • You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()

    单选题查看答案

  • You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()

    多选题查看答案

  • You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()

    多选题查看答案