In your multitenant container database (CDB) that contains pluggable database (PDBs),
you grant the CREATE TABLE privilege to the common user C##A_ADMIN in root and all of PDBs,
with one command. You then execute this command from the root container:
SQL> REVOKE create table FROM C##A_ADMIN;
What is the result?
A. It fails and reports and error because the CONTAINER=ALL clause is not used.
B. It fails and reports an error becuase the CONTAINER=CURRENT clause is not used.
C. It executes successfully and the CREATE TABLE privilege is revoked from C##A_ADMIN in all the PDBS.
D. It executes successfully and the CREATE TABLE privilege is revoked from C##A_ADMIN in root and all the PDBS.
E. It executes successfully and the CREATE TABLE privilege is revoked from C##A_ADMIN in root only.
Correct Answer: A