Oracle Exam 1Z0-148 Topic 7 Question 11 Discussion

Actual exam question for Oracle's 1Z0-148 exam

Question #: 11
Topic #: 7

[All 1Z0-148 Questions]

The user MY_USER has been assigned the roles CONNECT, RESOURCE, and DBA.

Which statement generates the DDL for these privileges?

ASELECT DBMS_METADATA.GET_GRANTED_DDL ('SYSTEM_GRANT', 'my_user') FROM dual;

BSELECT DBMS_METADATA.GET_GRANTED_DDL ('ROLE_GRANT', 'my_user') FROM dual;

CSELECT DBMS_METADATA.GET_GRANTED_DDL ('OBJECT_GRANT', 'my_user') FROM dual;

DSELECT DBMS_METADATA.GET_DDL ('USER', 'my_user') FROM dual;

Show Suggested Answer

Suggested Answer: D

by Herman at May 07, 2022, 12:15 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!