In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN. and
then execute the command:
Which statement is true?
A.
The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the
root database.
B.
The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root
database, as well as in the pluggable databases (PDBs).
C.
The command fails because the CONTAINER clause is not used.
D.
The command fails because system privileges cannot be granted to a common user.
Explanation:
For commonly granted privileges the grantor must be connected to the root and must specify
CONTAINER=ALL in the GRANT statement.
References: https://docs.oracle.com/database/121/DBSEG/authorization.htm