Oracle
1Z0-063 · Question #53
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; SQL>…
The correct answer is C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root. See the full explanation below for the reasoning.
Question
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; SQL> CREATE ROLE c##role1 CONTAINER=ALL; SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL; SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin; What is the result of the revoke command?
Options
- AIt executes successfully and the c##role1role is revoked from the c##a_admin user only in the
- BIt fails and reports an error because the container=all clause is not used.
- CIt executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root
- DIt fails and reports an error because the comtainer=current clause is not used.
How the community answered
(27 responses)- A11% (3)
- B7% (2)
- C78% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.