單項(xiàng)選擇題

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？（）

A. You must enable the row movement on the SCOTT.EMP table.
B. You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
C. You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
D. You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

你可能感興趣的試題

單項(xiàng)選擇題

You executed the following code：
SQL> CREATE TABLE COUNTRY
（COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，
COUNTRY_NAME VARCHAR2（20），
CURRENCY_NAME VARCHAR2（20），
CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））
ORGANIZATION INDEX；
In which tablespace will the mapping table be created？（）

A. SYSTEM tablespace
B. SYSAUX tablespace
C. Undo tablespace
D. The tablespace of the Index Organized Table （IOT）

單項(xiàng)選擇題

You issued the following statement：
SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；
What will be the result of issuing the above statement？（）

A.The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B. The command will not execute successfully because resumable space allocation is enabled at the session level.
C. The command will execute successfully and resumable space will be allocated at the session level.
D. The command will execute successfully and resumable space will be allocated at the instance level.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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？（）

你可能感興趣的試題

You issued the following statement： SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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？（）

You issued the following statement：
SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；
What will be the result of issuing the above statement？（）