Oracle Exam 1Z0-063 Topic 12 Question 2 Discussion

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

Question #: 2
Topic #: 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 ANY TABLE and SELECT ANY TABLE privileges.

You then execute the commands:

Which two statements are true? (Choose two.)

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 Pete at May 05, 2022, 06:03 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 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!