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

You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

Answer options

• A. by using the connect statement as a local user having only the set container privilege
• B. by using easy connect
• C. by using external authentication
• D. as a common user with the set container privilege
• E. by executing the alter session set container command as a local user

Correct answer: A, D

Explanation

The correct options, A and D, allow access to the PDB in read-only mode through the necessary privileges. Option A is valid because a local user with the set container privilege can connect to the PDB. Option D is also correct as common users can use the same privilege to access the PDB. Options B, C, and E do not provide the necessary access for read-only mode in this context.