- 单项选择题 Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_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.
关注下方微信公众号，在线模考后查看
- In which three cases
- Examine the structu
- Which three statemen
- What is necessary fo
- You are the DBA for
- Which SQL statement
- Which two statements
- Which two statements
- Examine the statemen
- The CUSTOMERS table
- Examine the descrip
- Which two are attrib
- For which two constr
- The EMPLOYEES table
- You need to modify t
- You need to create
- Which data dictionar
- Which two are charac
- For which action can
- Which statement desc