单选题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 tableB The high-water mark (HWM) for the BOOKIN

题目

单选题

Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）

The shrink operation touches every block in the BOOKING table

The high-water mark (HWM) for the BOOKING table is shifted from its original position

The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

参考答案和解析

正确答案： B

解析：暂无解析

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 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？（）AIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.BIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.CIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.DYou cannot shrink the SCOTT.EMP table.

点击查看答案
相关问题 2：

单选题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？（）AYou must enable the row movement on the SCOTT.EMP table.BYou must define the tablespace of the SCOTT.EMP table for automatic segment space management.CYou must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.DYou must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

点击查看答案
相关问题 3：

多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table（）AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark （HWM） is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command

点击查看答案
相关问题 4：

单选题You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A Immediately following statement execution B After the ALTER TABLE DROP UNUSED COLUMNS command is issued C After the ALTER TABLE SET UNUSED COLUMN command is issued D After the ALTER TABLE MODIFY command is issued

点击查看答案
相关问题 5：

单选题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.

点击查看答案
相关问题 6：

单选题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？（）AINCLUDING DEPENDENCIESBINCLUDING DEPENDENCIES CASCADECCOMPACTDCASCADEENone of the above

点击查看答案
相关问题 7：

单选题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 REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE

点击查看答案

OCP 11G认证考试

单选题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 tableB The high-water mark (HWM) for the BOOKIN

题目

参考答案和解析

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容