Oracle Exam 1Z0-063 Topic 5 Question 3 Discussion

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

Question #: 3
Topic #: 5

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?

AIt executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.

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 database and all the PDBs.

DIt fails and reports an error because the container=current clause is not used.

Show Suggested Answer

Suggested Answer: B

by Gregoria at May 09, 2022, 09:26 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!