Upgrade Oracle DBA 11g to Oracle Database 12c — Question 34

Which two statements are true about a common user?

Answer options

• A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
• B. A common user with the create user privilege can create other common users, as well as local users.
• C. A common user can be granted only a common role.
• D. A common user can have a local schema in a PDB.
• E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Correct answer: C, D

Explanation

The correct answers are C and D because a common user can only be assigned common roles, and they can indeed have a local schema within a PDB. Options A and B are incorrect as common users do not have privileges across PDBs or the ability to create both common and local users. Option E is also incorrect since a common user does not always use the global temporary tablespace at the CDB level.