What does this set of SQL statements do?

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?

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?

A.
The set of statements contains an error and does not work.

B.
It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES
object to the role, and gives the REGISTRAR role to three users.

C.
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
object to the role, and gives the REGISTRAR role to three users.

D.
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
object to the role, and creates three users with the role.

E.
It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the
REGISTRAR role to the STUDENT_GRADES object.

F.
It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and
gives the UPDATE role to the registrar.

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:

Athe statement does not contain error
Bthere is no MODIFY privilege
Dstatement does not create 3 users with the role
Eprivilege is grant to role then grant to user
Fprivilege is grant to role then grant to user



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Sadiq Al Sahaf (Sojib)

Sadiq Al Sahaf (Sojib)

Yes…
‘C’ is only the correct answer.

kiya

kiya

is this question part of this exam? please tell me
tnx