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.

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

A. TEST_TBS is a small file tablespace.

B. TEST_TBS is a bigfile tablespace (BFT).

C. TEST_TBS is the default temporary tablespace.

D. TEST_TBS is a dictionary-managed tablespace.

To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?

A. TRUNCATE the archive table.

B. DROP the Flashback Data Archive.

C. Nothing; expired rows are automatically removed.

D. Nothing; expired rows are moved to an archive table.

E. Delete entries from the archive where the metadata date retained is greater than the retention period.

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.

After some days, you want to change the status of the database backup and you issued the following command:

RMAN>CHANGE BACKUPSET 231 NOKEEP;

What is the implication of this command?

A. The backup is deleted.

B. The backup is marked unavailable.

C. The backup overrides the backup retention policy.

D. the backup becomes eligible for deletion according to the existing retention policy

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover

B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area