STUDY THIS SCRIPT (LINE NUMBERS HAVE BEEN ADDED)

7. Study this script (line numbers have been added):

1 create role hr_role identified by pass;2 grant create table to hr_role;3 grant select table to hr_role;4 grant connect to hr_role;

Which line will cause an error? (Choose the best answer.)

A. Line 1, because only users, not roles, have passwords.

B. Line 2, because only users, not roles, can create and own tables.

C. Line 3, because SELECT TABLE is not a privilege.

D. Line 4, because a role cannot have a system privilege in addition to table

privileges.