單項(xiàng)選擇題

Examine the CREATE DISKGROUP command used to create a disk group:

In which situation would you use this method of disk group creation?（）

A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

你可能感興趣的試題

單項(xiàng)選擇題

You executed the following commands in a database session:

What could have caused the recycle bin to clean up?（）

A. There is demand for space from the new table從
B. The undo tablespace does not have sufficient free space
C. The new table name is the same as the table name in the recycle bin
D. The temporary tablespace that is assigned to you does not have sufficient free space

單項(xiàng)選擇題

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

Examine the CREATE DISKGROUP command used to create a disk group: In which situation would you use this method of disk group creation?（）

你可能感興趣的試題

You executed the following commands in a database session: What could have caused the recycle bin to clean up?（）

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

Examine the CREATE DISKGROUP command used to create a disk group:

In which situation would you use this method of disk group creation?（）

You executed the following commands in a database session:

What could have caused the recycle bin to clean up?（）

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