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).
C
common user in a multitenant database with the SET CONTAINER privilege can use the “ALTER SESSION SET CONTAINER=” statement to swtich between databases including the root container. When you connect using this method, the AFTER LOGON trigger does not fire.
C