When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）
A: A INCLUDING DEPENDENCIES
B: B INCLUDING DEPENDENCIES CASCADE
C: C COMPACT
D: D CASCADE
E: E None of the above
A: A INCLUDING DEPENDENCIES
B: B INCLUDING DEPENDENCIES CASCADE
C: C COMPACT
D: D CASCADE
E: E None of the above
举一反三
- You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（） A: You must enable the block change tracking feature. B: You must have enable the flashback feature. C: You must use the OMF in your database. D: You must define the tablespace of the SCOT E: EMP table for automatic segment space management.
- You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（） A: You must enable the block change tracking feature. B: You must have enable the flashback feature. C: You must use the OMF in your database. D: You must define the tablespace of the SCOTEMP table for automatic segment space management.
- You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： A: The table is partitioned B: The table name is wrong. C: It is an index-Organized table （IOT） D: The table is stored in locally managedtablespace. E: The table is stored in atablespacewhere segment space is managed manually.
- What should you avoid in any lead? A: Burying the news B: Starting with a question C: Including too much information D: All of the above
- In which scenario will you use the Flashback Transaction Query feature？（） A: when you want to restore an important table that is dropped from the Recycle Bin B: when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction C: when you want to restore a dropped user’s schema D: when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period