Exam 1z0-063 topic 1 question 204 discussion

Actual exam question from Oracle's 1z0-063

Question #: 204
Topic #: 1

[All 1z0-063 Questions]

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

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).

Show Suggested Answer

Suggested Answer: D 🗳️
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.
References: https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm

by alipilot2006 at April 25, 2019, 9:01 a.m.