Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:SQL> CREATE USER c##a_adminIDENTIFIED BY passwordDEFAULT TABLESPACE usersQUOTA I00M ON usersTEMPORARY TABLESPACE temp;Which statement is true about the execution of the command?When creating a common user, any tablespace, tablespace group or profile specified in the CREATE command must exist in every PDB. If none of these are specified, the default TABLESPACE, TEMPORARY TABLESPACE, and PROFILE for the PDB will be used.
Question:
Which statement is true about the execution of the command?
Options:
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.
The command succeeds only if all the PDBs have the users and temp tablespaces.
The command gives an error because the container=all clause is missing.
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 not exist in that PDB.
Correct Answer
The Correct Answer for this Question is
The command succeeds only if all the PDBs have the users and temp tablespaces.