Oracle
1Z0-063 · Question #209
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?
The correct answer is D. It cannot be used to connect to PDB$SEED. The current container can be the root or a PDB. The current container can be CDB$ROOT (root) only for common users. The current container can be a particular PDB for both common users and local users.
Core Concepts and Tools
Question
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?
Options
- AIt can be executed only from CDB$ROOT.
- BIt rolls back any pending transactions in the container from which it is executed.
- CIt will not fire login triggers for the specified container.
- DIt cannot be used to connect to PDB$SEED.
- EIt cannot be used to connect to CDB$ROOT from a pluggable database (PDB).
How the community answered
(17 responses)- A12% (2)
- B12% (2)
- D71% (12)
- E6% (1)
Explanation
The current container can be the root or a PDB. The current container can be CDB$ROOT (root) only for common users. The current container can be a particular PDB for both common users and local users.
Topics
#ALTER SESSION SET CONTAINER#container switching#PDB$SEED#multitenant
Community Discussion
No community discussion yet for this question.