You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:
SQL> CREATE PUGGABLE DATABASE NEW_PDB ADMIN USER PDB_ADMIN IDENTIFIED NBYSECRET;
Pluggable database created.
SQL> ALTER PLUGGABLE DATABASE NEW_PDB OPEN;
Pluggable database altered.
SQL> ALTER SESSION SET CONTAINER = NEW_PDB;
Session altered.
SQL> GRANT CONNECT TO PDB_ADMIN;
Grant succeeded.
SQL CONNECT PDB_ADMIN/SECRET@LOCALHOST/NEW_PDB
Connected.
SQL> SELECT * FROM SESSION_PRIVS;
PRIVILEGE
-------------------------------------------------------------------------
CREATE SESSION
SET CONTAINER
SQL> ALTER SESSION SET CONTAINER = PDB$SEED;
What is the result of the last SET CONTAINER statement and why is it so?
A. It succeeds because the PDB_ADMIN user has the required privileges.
B. It fails because common users are unable to use the SET CONTAINER statement.
C. It fails because local users are unable to use the SET CONTAINER statement.
D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target
pluggable database (PDB).
Correct Answer: C
QUESTION 104-local users unable SET CONTAINER
最新推荐文章于 2022-05-13 11:05:00 发布