Oracle
1Z0-063 · Question #181
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): Which statement is true about granting the select privilege on the…
The correct answer is C. The command succeeds and the common user c##admin can create a session and query the. See the full explanation below for the reasoning.
Question
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
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 c##admin can create a session and query the
- DThe command succeeds and the common user c##admin can create a session in cdb$root and all
- EThe command succeeds and the common user c##admin can create a session and query the
How the community answered
(28 responses)- A11% (3)
- C79% (22)
- D7% (2)
- E4% (1)
Community Discussion
No community discussion yet for this question.