Oracle Database 12c: Installation and Administration — Question 249

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # #
A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

Answer options

• A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• B. It fails and reports an error because the CONTAINER=ALL clause is not used.
• C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
• E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Correct answer: A

Explanation

The correct answer is A because the REVOKE command without any container clause affects only the root container. Options B and D are incorrect as they refer to missing clauses that are irrelevant in this context. Option C is wrong because the privilege is not revoked from all PDBs, and option E incorrectly states that the privilege is revoked from all PDBs.