Oracle Database 12c: Advanced Administration — Question 31

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

Option C is correct because a common user is limited to being granted common roles only, while option D is also correct as a common user can indeed have a local schema within a PDB. The other options are incorrect as they either misrepresent the privileges of common users or describe behaviors that do not apply to them.