单项选择题
You executed the following PL/SQL block successfully：
VARIABLE tname VARCHAR2（20）
BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；
：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）；
END； /
Then you executed the following command：
SQL> SELECT dbms_addm.get_report（：tname） FROM DUAL；
The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）
A. with the CPU Usage finding if it is less than 90
B. without the CPU Usage finding if it is less than 90
C. with the CPU Usage finding for snapshots below 90
D. with the CPU Usage finding for snapshots not between 150 and 162
相关考题
-
单项选择题
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）
A. Check the alert log file
B. Query the V$FLASHBACK_DATABASE_LOG view
C. Query the V$RECOVERY_FILE_DEST_SIZE view
D. Query the V$FLASHBACK_DATABASE_STAT view
E. Check the value assigned for the UNDO_RETENTION parameter -
多项选择题
You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)
A. The KEEP option overrides the configured retention policy
B. The KEEP option is an attribute of an individual backup piece
C. The backup contains only data files and archived redo log files
D. The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled -
多项选择题
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)
A. You must configure block change tracking file
B. You must have first level 1 backups for RMAN to restore blocks
C. You must ensure that the SALES database is mounted or open
D. You must have full or level 0 backups for RMAN to restore blocks
E. You must take the tools01.dbf data file offline before you start a block media recovery
