试题详情
- 单项选择题You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）
A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
关注下方微信公众号，在线模考后查看
热门试题
- Which operator can b
- From SQL*Plus, you
- The CUSTOMERS table
- Which constraint can
- Examine the descrip
- Which object privile
- The EMP table has t
- Which SQL statement
- Which SQL statement
- ClicktheExhibitbutto
- Examine these state
- You created a view
- Exhibit: Examinethe
- Which are iSQL*Plus
- You need to perform
- Evaluate the SQL st
- Examinethedatafromth
- Evaluate the SQL st
- Examine the descrip
- Examine the structu