nerdexam
Oracle

1Z0-061 · Question #259

Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)

The correct answer is B. It allows the MANAGER to pass the specified privileges on to other users. E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES. GRANT ROLE to ROLE/USER

Controlling User Access

Question

Examine the statement:

GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)

Options

  • AMANAGER must be a role.
  • BIt allows the MANAGER to pass the specified privileges on to other users.
  • CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
  • DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
  • EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES
  • FIt allows the MANAGER the ability to select from, delete from, and update the

How the community answered

(34 responses)
  • B
    79% (27)
  • C
    3% (1)
  • D
    12% (4)
  • F
    6% (2)

Explanation

GRANT ROLE to ROLE/USER

Topics

#GRANT#WITH GRANT OPTION#object privileges#DML privileges

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice