Oracle Database 12c: Advanced Administration — Question 44

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:

SQL> CREATE USER c##a_admin -

IDENTIFIED BY password -

DEFAULT TABLESPACE users -

QUOTA I00M ON users -
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

Answer options

• A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
• B. The command succeeds only if all the PDBs have the users and temp tablespaces.
• C. The command gives an error because the container=all clause is missing.
• D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does

Correct answer: A

Explanation

The correct answer is A because creating a common user in a CDB ensures that it is available in all associated PDBs and utilizes the CDB's tablespaces for schema objects. Option B is incorrect as the command does not require all PDBs to have the specified tablespaces. Option C is wrong because the absence of the container=all clause does not prevent the command from executing successfully. Option D is misleading as it implies a dependency on the PDB's tablespace configuration, which is not a requirement for creating a common user.