Oracle Exam 1Z0-067 Topic 11 Question 61 Discussion

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

Question #: 61
Topic #: 11

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

SQL> CREATE ROLE c ##role1 CONTAINER-ALL;

SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;

SQL>CREATE USER c##admin IDENTIFIED BY orcl123;

SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;

SQL> GRANT SELECT ON DBA_USERS to c##role1 CONTAINER*ALL;

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

AThe command fails and gives an error because object privileges cannot be granted to a common user.

BThe command fails because container is not set to current.

CThe command succeeds and the common user c##admin can create a session and query the DBA_users view in CDB$ROOT and all the PDBs.

DThe command succeeds and the common user c##admin can create a session in CDB$ROOT and all the PDBs, but can only query the dba_users view in CDB$ROOT

EThe command succeeds and the common user c##admin can create a session and query the DBA users view only in CDB$ROOT

Show Suggested Answer

Suggested Answer: C

by Kattie at Nov 21, 2022, 10:58 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-067 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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