Oracle Database 12c: Installation and Administration — Question 120

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:

THREADED_EXECUTION = FALSE -
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

Answer options

• A. You can conned as a common user by using the connect statement.
• B. You can connect as a local user by using the connect statement.
• C. You can connect by using easy connect.
• D. You can connect by using OS authentication.
• E. You can connect by using a Net Service name.
• F. You can connect as a local user by using the SET CONTAINER statement.

Correct answer: A, C, D, E

Explanation

The correct answers A, C, D, and E are valid methods for connecting to the root of a CDB in read-only mode. Option B is incorrect because local users cannot connect in this scenario, and option F is also incorrect since the SET CONTAINER statement is not applicable for establishing connections in read-only mode.