What is the result?

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?

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.

Explanation:
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’
Oracle Database SQL Language Reference 12c, Revoke