Upgrade to Oracle Database 12c — Question 5

Your multitenant container database (CDB) contains several pluggable databases (PDBs).
A common user C##A_ADMIN, is created with connect privileges.
You execute this command from the root container:
SQL> GRANT create tablespace to C##A_ADMIN;
Which statement is true?

Answer options

• A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root container.
• B. The command fails because the CONTAINER=ALL clause is not used.
• C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root container as well as in the PDBs.
• D. The command fails because the CONTAINER=CURRENT clause is not used.

Correct answer: C

Explanation

The correct answer is C because granting the create tablespace privilege to a common user from the root container allows that user to create tablespaces in both the root and PDBs. Option A is incorrect as it limits the privilege to the root container only, while options B and D incorrectly state that the command fails due to the absence of specific CONTAINER clauses.