In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # in root and all PDBs. You execute the following command from the root container: A_ADMIN - 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.

B

SQL> create user c##admin identified by stipsi container=all; User created. SQL> grant create table to c##admin container=all; Grant succeeded. SQL> revoke create table from c##admin; revoke create table from c##admin * ERROR at line 1: ORA-65092: system privilege granted with a different scope to `C##ADMIN`