nerdexam
Oracle

1Z0-083 · Question #160

1Z0-083 Question #160: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #160. The question stem and answer options stay visible for context.

Question

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; What is true?

Options

  • AIt will return an error because creation of a local role is not allowed in CDB$ROOT.
  • BROLE1 will be created only in CDB$ROOT and APP1_ROOT.
  • CROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
  • DROLE1 will be created only in CDB$ROOT.
  • EIt will return an error because common roles must start with C##.

Unlock 1Z0-083 to see the answer

You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-083 Practice