單項選擇題

Evaluate the following command：
SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）
LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；
Which statement is true regarding the above command？（）

A. The LOB values are automatically compressed.
B. The LOB values are cached by default in the buffer cache.
C. The LOB values are automatically stored in encrypted mode.
D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

你可能感興趣的試題

單項選擇題

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below：
LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’
Examine the following RMAN command issued to set the deletion policy for archived log files：
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt；
Which statement is true regarding what this command accomplishes？（）

A. All archived redo log files backed up at least twice to tape are deleted.
B. All archived redo log files backed up at least once to tape are eligible for deletion.
C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

單項選擇題

Consider the following scenario for your database:
- Backup optimization is enabled in RMAN.
- The recovery window is set to 7 days in RMAN.
- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
- The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk.
Which statement is true regarding the backup of the TOOLS tablespace?（）

A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Evaluate the following command： SQL> CREATE TABLE design_data （id NUMBER， doc CLOB） LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）； Which statement is true regarding the above command？（）

你可能感興趣的試題

Evaluate the following command：
SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）
LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；
Which statement is true regarding the above command？（）