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
  4% (2)
• B
  2% (1)
• C
  77% (36)
• D
  6% (3)
• F
  11% (5)

Explanation

the statement will create a role call REGISTRAR, grant UPDATE on student_grades to registrar, grant the role to user1,user2 and user3. Incorrect answer: A the statement does not contain error B there is no MODIFY privilege D statement does not create 3 users with the role E privilege is grant to role then grant to user F privilege is grant to role then grant to user

No community discussion yet for this question.