READ Free Dumps For Oracle- 1z0-050
Question ID 1821 | Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.) |
Option A | A. It can be used to allow the access privilege settings for users but not roles. |
Option B | B. It can be used to allow the access privilege settings for users as well as roles. |
Option C | C. It can be used to control the time interval for which the access privilege is available to a user. |
Option D | D. It can be used to selectively restrict the access for each user in a database to different host computers. |
Option E | 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 1822 | To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: |
Option A | A. A template needs to be associated with the task. |
Option B | B. A workload needs to be associated with the task. |
Option C | C. The partial or complete workload scope needs to be associated with the task. |
Option D | D. The type of structures (indexes, materialized views, or partitions) to be recommended need to |
Correct Answer | B |