READ Free Dumps For Oracle- 1z0-050
Question ID 6013 | Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose
| ||||||
Option A | Health Monitor checks are always initiated manually when there is some critical error. | ||||||
Option B | Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption | ||||||
Option C | Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically. | ||||||
Option D | Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent. | ||||||
Correct Answer | B,D |
Question ID 6014 | You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of l/Os. Which statement describes a solution to the above? |
Option A | Set a threshold for the default system-defined moving window baseline. |
Option B | Add directives to the Automatic Database Diagnostic Monitor (ADDM). |
Option C | Modify the profile for the targeted users for which control needs to be imposed. |
Option D | Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives. |
Correct Answer | D |