READ Free Dumps For Oracle- 1z0-050
| Question ID 6069 | You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this? |
| Option A | Edit the automatic maintenance window group configuration. |
| Option B | Set the CURSOR_SHARING parameter to EXACT for the database instance. |
| Option C | Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE. |
| Option D | Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance. |
| Correct Answer | C |
| Question ID 6070 | Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.) |
| Option A | It repairs blocks that have read disk I/O errors |
| Option B | It repairs blocks by always reading them from the mirror copy and writing them to the original location. |
| Option C | It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly. |
| Correct Answer | A,D |