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.
SELECT student_name, subject1
FROM marks
WHERE subject1 > AVG(subject1);

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.
SELECT student_name, SUM(subject1)
FROM marks
WHERE student_name LIKE ‘R%’;

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.
SELECT SUM(subject1+subject2+subject3)
FROM marks
WHERE student_name IS NULL;

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.
SELECT SUM(DISTINCT NVL(subject1, 0)), MAX(subject1)
FROM marks
WHERE subject1 > subject2;

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.
privilege is grant to role then grant to user
QUESTION 121
Examine the structure of the MARKS table:
Exhibit:

Which two statements would execute successfully? (Choose two.)

F.
It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the
UPDATE role to the registrar.
privilege is grant to role then grant to user
QUESTION 121
Examine the structure of the MARKS table:
Exhibit:

Which two statements would execute successfully? (Choose two.)

A.
The set of statements contains an error and does not work.
SELECT student_name, subject1
FROM marks
WHERE subject1 > AVG(subject1);

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.
SELECT student_name, SUM(subject1)
FROM marks
WHERE student_name LIKE ‘R%’;

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.
SELECT SUM(subject1+subject2+subject3)
FROM marks
WHERE student_name IS NULL;

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.
SELECT SUM(DISTINCT NVL(subject1, 0)), MAX(subject1)
FROM marks
WHERE subject1 > subject2;

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