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.
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 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.
- 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: alter table emp delete column addcolumn; B: alter table emp modify column addcolumn char(10); C: alter table emp change addcolumn addcolumn int; D: alter table emp add column addcolumn int;
- 查询scott用户的emp表中的总记录数,可以使用下列哪个语句?() A: SELECT MAX(empno) FROM scott.emp; B: SELECT<br/>COUNT(empno) FROM scott.emp; C: SELECT COUNT(comm) FROM scott.emp; D: SELECT COUNT(*) FROM scott.emp;