单选题

You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()

A You must enable the row movement on the SCOTT.EMP table.

B You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

C You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.

D You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You are configuring for Oracle Shared Server. Which service is required? ()

    单选题查看答案

  • You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

    多选题查看答案

  • How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()

    单选题查看答案

  • In which situation are you NOT required to perform an incomplete recovery?()

    单选题查看答案

  • You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()

    单选题查看答案

  • You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()  

    单选题查看答案

  • You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()

    单选题查看答案

  • You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()

    多选题查看答案

  • Which command would you use to determine what database backups are currently available for restore?()

    单选题查看答案

  • Which command would you use to determine what database backups are currently available for restore?()  

    单选题查看答案