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.
正确答案
答案解析
相似试题
(单选题)
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?()