READ Free Dumps For Oracle- 1z0-050
| Question ID 5973 | Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.) |
| Option A | It can be used to backup all data on ASM disks. |
| Option B | It can be used to re-create the ASM disk group with its attributes. |
| Option C | It can be used to recover the damaged ASM disk group along with the data. |
| Option D | It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure. |
| Correct Answer | B,D |
| Question ID 5974 |
BEGIN dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage1, FINDING_NAME=>'CPU Usage1, 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 |
| Option A | with the CPU Usage finding if it is less than 90 |
| Option B | without the CPU Usage finding if it is less than 90 |
| Option C | with the CPU Usage finding for snapshots below 90 |
| Option D | with the CPU Usage finding for snapshots not between 150 and 162 |
| Correct Answer | B |
You executed the following PL/SQL block successfully: VARIABLE tname VARCHAR2(20)