Oracle
1Z0-060 · Question #207
1Z0-060 Question #207: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
Question
Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users and have only connect privileges. C##A_ADMIN B_ADMIN You create a common role with common privileges C##_ROLE1 CREATE TABLE and SELECT ANY TABLE. You then execute these commands to grant the role to users in the root container: SQL > GRANT C##_role1 TO c##_a_admin CONTAINER=ALL; Then, SQL> CONN sys/oracle@HR_PDB as sysdba SQL> GRANT c##_role1 TO b_admin CONTAINER=CURRENT; Which two statements are true? (Choose two.)
Options
- AC##_A_ADMIN can create and select any table in the root container as well as in all current PDBs.
- BC##_A_ADMIN can create and select any table in the root container as well as in all current and
- CC##_A_ADMIN can create and select any table, and grant the C##_ROLE1 role to users in the
- DB_ADMIN can create and select any table, and grant the C##_ROLE1 role to users in HR_PDB.
- EB_ADMIN can create and select any table in HR_PDB
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.