（单选题）
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
正确答案
答案解析
略
相似试题
（单选题）
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？（）
