Oracle
1Z0-071 · Question #184
SCOTT is a user in the database. Evaluate the commands issued by the DBA: Which statement is true regarding the execution of the above commands?
The correct answer is B. Statement 2 would not execute because system privileges and object privileges cannot be. See the full explanation below for the reasoning.
Question
SCOTT is a user in the database. Evaluate the commands issued by the DBA:
Which statement is true regarding the execution of the above commands?
Options
- AStatement 1 would not execute because the WITH GRANT option is missing.
- BStatement 2 would not execute because system privileges and object privileges cannot be
- CStatement 3 would not execute because role and system privileges cannot be granted together in
- DStatement 1 would not execute because the IDENTIFIED BY <password> clause is missing.
How the community answered
(48 responses)- A4% (2)
- B71% (34)
- C17% (8)
- D8% (4)
Community Discussion
No community discussion yet for this question.