Examine these statements: CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?

Question

Options

• AThe set of statements contains an error and does not work.
• BIt creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES
• CIt creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
• DIt creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
• EIt creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the
• FIt creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and

• A
  6% (2)
• B
  13% (4)
• C
  74% (23)
• D
  3% (1)
• F
  3% (1)

Explanation

The statement will create a role call REGISTRAR, grant UPDATE on student_grades to registrar, grant the role to user1, user2 and user3.

No community discussion yet for this question.