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.
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.
举一反三
- 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 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.
- 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
- Which type of table space should be used to allow the operating system to allocatepages to the table space as needed?
- In class, each student has his own table and chair, the space centering on the table and chair is his body territory.