ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

12 / 155

Question 12:

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: 
image
Which two statements are true? 

Answer options:

A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
B. B_admin can create and select any table in both the root container and hr_pdb.
C. c##admin can create and select any table in the root container and all the PDBs.
D. B_admin can create and select any table only in hr_pdb.
E. The grant c##role1 to b_admin command returns an error because container should be set to ALL.