Oracle Exam 1Z0-067 Topic 11 Question 1 Discussion

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

Question #: 1
Topic #: 11

Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.

You create a common role c##role1 with the create table and select any table privileges.

You then execute the commands:

SQL> GRANTc##role1 TO##Madmin CONTAINER=ALL;

SQL>CONNsys/oracle@HR_PDB as sysdba

SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;

Which two statements are true?

AC##admin can create and select any table, and grant the c##role1 role to users only in the root container.

BB_admin can create and select any table in both the root container and Hr_pdb.

Cc##admin can create and select any table in the root container and all the PDBs.

DB_admin can create and select any table only in hr_pdb.

EThe grant c##role1 to b_admin command returns an error because container should be set to ALL.

Show Suggested Answer

Suggested Answer: C, D

by Cammy at May 09, 2022, 10:37 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!