单项选择题
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:
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.
相关考题
-
单项选择题
View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?（）
A. Another repair session is running concurrently.
B. The failure ID has not been mentioned in the command for data file 5.
C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command. -
单项选择题
Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（）
A. It executes successfully but partition pruning cannot happen for this partition key.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions. -
多项选择题
You set the following parameters in the parameter file and restarted the database: Which two statements are true regarding these parameters after the database instance is restarted?（）
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
