nerdexam
Oracle

1Z0-063 · Question #64

Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): SQL> CREATE ROLE c ##role1 CONTAINER-ALL; SQL> GRANT CREATE…

The correct answer is C. The command succeeds and the common user cmadnxn can create a session and query the. See the full explanation below for the reasoning.

Question

Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): SQL> CREATE ROLE c ##role1 CONTAINER-ALL; SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL; SQL> CREATE USER c##adnin IDENTIFIED BY orcl123; SQL> GRANT c##role1 TO c##admin CONTAINER=ALL; SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL; Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

Options

  • AThe command fails and gives an error because object privileges cannot be granted to a common
  • BThe command fails because container is not set to current.
  • CThe command succeeds and the common user cmadnxn can create a session and query the
  • DThe command succeeds and the common user ct (admin can create a session in cdbSroot and
  • EThe command succeeds and the common user c#(admin can create a session and query the

How the community answered

(19 responses)
  • B
    5% (1)
  • C
    79% (15)
  • D
    11% (2)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-063 Practice