单选题Examine the following command： SQL> ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）AThe shrink operation touches every block in the BOOKING tableBThe high-water mark （HWM） for the BOOK

题目

单选题

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

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()

A. It collects statistics into the pending area in the data dictionary

B. It creates a virtual hidden column in the CUSTOMERS_OBE table

C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

D. It creates a histogram to hold skewed information about the data in the columns

参考答案：B

第2题：

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）

A、 Index-organized table
B、 Mapping Table
C、 Clustered Table
D、 Journal Table

正确答案:D

第3题：

View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）

A. An error is produced.

B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

参考答案：B

第4题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）

A、The table is moved to the SYSAUX tablespace.
B、The table is moved to the SYSTEM tablespace.
C、The table is removed from the database permanently.
D、The table is renamed and remains in the TBSFD tablespace.

正确答案:D

第5题：

You executed the following commands： SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）

A、 The statistics are stored in the pending statistics table in the data dictionary.
B、 The statistics are treated as the current statistics by the optimizer for all sessions.
C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.
D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.

正确答案:A

第6题：

Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?()

A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

参考答案：A, C, D

第7题：

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

正确答案:B

第8题：

Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）

A. All three tables in the recycle bin are purged

B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin

D. Only the table with the latest DROPSCN is purged

参考答案：B

第9题：

Examine the commands executed in the following sequence： 1：SQL> CREATE ROLE mgrrole； 2：SQL> GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL> GRANT select，update ON sh.sales TO mgrrole； 4：SQL> CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL> GRANT ceo TO mgrrole； Which statement is true about the above commands（）

A、The commands execute successfully.
B、Command 6 produces an error because of circular role grant.
C、Command 5 produces an error because a role cannot be granted to another role.
D、Command 3 produces an error because the MGRROLE role already contains system privileges.
E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

正确答案:B

第10题：

Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

A、The constraint remains valid.
B、The index on the constraint is dropped.
C、It allows the loading of data into the table using SQL*Loader.
D、New data conforms to the constraint， but existing data is not checked
E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

正确答案:A,B,C

Examine the following command： SQL> ALTER TABLE booking SH

题目

相似问题和答案

更多相关问题

相关内容