hiexam
oracle · 1z0-062 · Q606 · multiple_choice · topic_1

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the foll…

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

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.

Start tracked practicePricing