READ Free Dumps For Oracle- 1z0-050
| Question ID 5975 | Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.) |
| Option A | It can be used to allow the access privilege settings for users but not roles. |
| Option B | It can be used to allow the access privilege settings for users as well as roles. |
| Option C | It can be used to control the time interval for which the access privilege is available to a user. |
| Option D | It can be used to selectively restrict the access for each user in a database to different host computers. |
| Option E | It can be used to selectively restrict a user's access to different applications in a specific host computer. |
| Correct Answer | B,C,D |
| Question ID 5976 | To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: BEGIN dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l); END; / BEGIN dbms_advisor.set_task_ parameter(lTASK1l,lANALYSIS_SCOPElllALLl); dbms_advisor.set_task_ parameter(lTASK1,,,MODE,llCOMPREHENSIVEl); END; / BEGIN dbms_advisor.execute_task('TASK1'); dbms_output.put_line(dbms_advisor.get_task_script('TASK11)); END; / The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason? |
| Option A | A template needs to be associated with the task. |
| Option B | A workload needs to be associated with the task. |
| Option C | The partial or complete workload scope needs to be associated with the task. |
| Option D |
|
| Correct Answer | B |
The type of structures (indexes, materialized views, or partitions) to be recommended need tobe specified for the task.