單項選擇題

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.

你可能感興趣的試題

多項選擇題

The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal
FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? （）

A. ARCHIVELOG mode must be enabled
B. Row Movement must be enabled for the table
C. FLASHBACK must be set to ON for the database
D. The UNDO_MANAGEMENT parameter must be set to AUTO
E. The UNDO_RETENTION parameter must be set appropriately

單項選擇題

You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M
TABLESPACE GROUP '';
Which statement regarding the above command is correct?（）

A. It will create the tablespace TEMP1 in group G1.
B. It will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group.

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

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

你可能感興趣的試題

The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? （）

You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）

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

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

The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal
FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? （）

You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M
TABLESPACE GROUP '';
Which statement regarding the above command is correct?（）