Which statement is true about the ALTER SESSION SET CON…

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

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

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *