# 1z0-062 — Question 606

**Type:** multiple_choice
**Topics:** topic_1

## Question

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:
//IMG//

What is the result of the last SET CONTAINER statement and why is it so?

## Correct Answer

_See scenario._

## Explanation

Answer is C:

SQL> create pluggable database cdb1pdb3 admin user cdb1pdb3_admin identified by password file_name_convert=(‘/oradata/CDB1/pdbseed’,’/oradata/CDB1/CDB1PDB3′) ;

Pluggable database created.

SQL> alter pluggable database cdb1pdb3 open;

Pluggable database altered.

SQL> alter session set container=cdb1pdb3
2 /

Session altered.

SQL> grant connect to cdb1pdb3_admin;

Grant succeeded.

SQL> connect cdb1pdb3_admin/password@nonrac12c-oel6u5/cdb1pdb3
Connected.
SQL> select * from session_privs;

PRIVILEGE
—————————————-
SET CONTAINER
CREATE PLUGGABLE DATABASE
CREATE SESSION

SQL> alter session set container=PDB$SEED;
ERROR:
ORA-01031: insufficient privileges

SQL>

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/oracle/1z0-062/606  
Practice (tracked): https://hiexam.net/study/1z0-062/practice