单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A The data in the segment will be compacted but t

第1题：

You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

• A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
• B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
• C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
• D、 You cannot shrink the SCOTT.EMP table.

第2题：

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、 INCLUDING DEPENDENCIES
• B、 INCLUDING DEPENDENCIES CASCADE
• C、 COMPACT
• D、 CASCADE
• E、 None of the above

第3题：

You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）

• A、It may advise the use of online table redefinition for tables in dictionary managed tablespace.
• B、It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
• C、It may advise the use of online table redefinition for tables in locally managed tablespaces
• D、It will detect and advise about chained rows.
• E、It may advise the use of segment shrink for free list managed tables.

第4题：

You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

• A、 SQL Tuning Advisor
• B、 SQL Access Advisor
• C、 Undo Advisor
• D、 Segment Advisor

第5题：

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：   ERROR at Line 1：   ORA-10635： Invalid segment or tablespace type   What could be the reason？ （）

• 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.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

• A、REBUILD
• B、CASCADE
• C、TRUNCATE
• D、ROW MOVEMENT
• E、SHRINK SPACE COMPACT
• F、SHRINK SPACE CASCADE

第14题：

Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）

• A、 The shrink operation touches every block in the BOOKING table
• B、 The high-water mark （HWM） for the BOOKING table is shifted from its original position
• C、 The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
• D、 The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

第15题：

You work as a database administrator for Certkiller .com. 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：  ERROR at Line 1：  ORA-10635： Invalid segment ortablespacetype What could be the reason？（）

• 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.

第16题：

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

• A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
• B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
• C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
• D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：