Your multitenant container database (CDB) contains multiple pluggable databases (PDBs).
You execute the command to create a common user: Exhibit: Which statement is true about
the execution of the command?
A.
The command succeeds only if all the PDBs have the users and temp tablespaces.
B.
The command gives an error because the container=all clause is missing.
C.
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.
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 not exist in that
PDB.
A
C
Common User:- A common user is created in root CDB. Common user can connect to root CDB and all PDB’s including future PDB’s which you may plug.
A!
SQL> create tablespace x datafile size 10m;
Tablespace created.
SQL> create user c##x1 identified by x default tablespace x temporary tablespace temp;
create user c##x1 identified by x default tablespace x temporary tablespace temp
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database PDB11
ORA-00959: tablespace ‘X’ does not exist
SQL>
Worng!
C is the correct answer .
Just create the user in cdb is will be a common user
Make the default tablespace as USERS on CDB .
eventhough you do not have tablespace on the PDB it will use the users tablespace of CDB.
I have tested it.