多项选择题

Which two statements are true about the Automatic Diagnostic Repository （ADR）？（）

A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script， which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances

<上一题目录下一题>

热门试题

多项选择题YouwanttotakeacompletedatabasebackupusingRMAN.Thebackupshouldconsistonlytheusedblocksfromyourdatabase.Whichtwostatementsaretrueaboutthisbackupoperation？（）

A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager

多项选择题Whichoptionswouldyouconsiderwhileconfiguringaflashrecoveryareafastrecoveryareain11gRelease2foryourproductiondatabasethatisrunninginARCHIVELOGmode？（）

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

多项选择题Toenablefasterincrementalbackups，youenabledblockchangetrackingforthedatabase.Whichtwostatementsaretrueabouttheblockchangetrackingfile？（）

A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.

单项选择题View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation： RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； } What is the multiplexing level in the preceding backup process？（）

A. 4
B. 8
C. 7
D. 0

单项选择题You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this： 1. Set the retention target： SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320； 2. Enable Flashback Database： SQL> ALTER DATABASE FLASHBACK ON； 3. Mount the database： SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE 5. Open the database： SQL> ALTER DATABASE OPEN； Choose the correct sequence.（）

A. 4， 1， 3， 2， 5
B. 4， 3， 1， 2， 5
C. 2， 4， 3， 5， 1
D. 4， 2， 5， 3， 1