nerdexam
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)
  • A
    4% (2)
  • B
    71% (34)
  • C
    17% (8)
  • D
    8% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice