Oracle
1Z0-067 · Question #149
1Z0-067 Question #149: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #149. The question stem and answer options stay visible for context.
Question
Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): SQL> CREATE ROLE c ##role1 CONTAINER-ALL; SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL; SQL> CREATE USER c##adnin IDENTIFIED BY orcl123; SQL> GRANT c##role1 TO c##admin CONTAINER=ALL; SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL; Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?
Options
- AThe command fails and gives an error because object privileges cannot be granted to a common
- BThe command fails because container is not set to current.
- CThe command succeeds and the common user cmadnxn can create a session and query the
- DThe command succeeds and the common user ct (admin can create a session in cdbSroot and all
- EThe command succeeds and the common user c#(admin can create a session and query the
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 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.