Oracle
1Z0-063 · Question #54
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…
The correct answer is 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. See the full explanation below for the reasoning.
Question
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 TOcMadmin CONTAINER=ALL; SQL> CONNsys/oracle@HR_PDB assysdba SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT; Which two statements are true?
Options
- AC##admin can create and select any table, and grant the c##role1 role to users only in the root
- BB_admin can create and select any table in both the root container and kr_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
How the community answered
(50 responses)- A4% (2)
- B16% (8)
- C74% (37)
- E6% (3)
Community Discussion
No community discussion yet for this question.