Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOT is an application container contained in…

Question

Exhibit

Options

• AAPP1_USER1 can be created in PDB1.
• BAPP1_USER1 can be created in CDB1.
• CAPP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
• DC##_APP_USER1 can be created in CDB1.
• EP1_USER1 can be created in CDB1.
• FC##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

• A
  75% (27)
• B
  6% (2)
• C
  3% (1)
• E
  3% (1)
• F
  14% (5)

Explanation

For the common user: The username must be unique across all containers. So D is correct because APP_USER1 is different from APP1_USER1 in APP1_ROOT B,E are wrong because you can only create local user in specific PDB. A is true because APP1_USER1 is unique in PDB1 F is false because common user will not have the same privileges and role unless you grant it with option CONTAINER=ALL;

No community discussion yet for this question.