Oracle Database 12c: Advanced Administration — Question 11

Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

Answer options

• A. It can be executed only from CDB$ROOT.
• B. It rolls back any pending transactions in the container from which it is executed.
• C. It will not fire login triggers for the specified container.
• D. It cannot be used to connect to PDB$SEED.
• E. It cannot be used to connect to CDB$ROOT from a pluggable database (PDB).

Correct answer: D

Explanation

The correct answer is D because the ALTER SESSION SET CONTAINER command cannot establish a connection to PDB$SEED, as it is meant for special purposes. Options A, B, and C are incorrect because they misrepresent the behavior of the command regarding transaction handling and triggers. Option E is also incorrect because it is possible to connect to CDB$ROOT from a PDB.