多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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

  • A、The data in the segment will be compacted but the high water mark will not be adjusted 
  • B、The EMPLOYEES table will be changed to read-only mode during the shrink operation 
  • C、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
  • D、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 
  • E、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题