使角色 R1 拥有 Student 表的 SELECT、UPDATE、INSERT 权限的语句是
A: GRANT SELECT, UPDATE, INSERT ON TABLE Student to R1
B: REVOKE SELECT, UPDATE, INSERT ON TABLE Student to R1
C: AUDIT SELECT, UPDATE, INSERT ON TABLE Student to R1
D: ROLE SELECT, UPDATE, INSERT ON TABLE Student to R1
A: GRANT SELECT, UPDATE, INSERT ON TABLE Student to R1
B: REVOKE SELECT, UPDATE, INSERT ON TABLE Student to R1
C: AUDIT SELECT, UPDATE, INSERT ON TABLE Student to R1
D: ROLE SELECT, UPDATE, INSERT ON TABLE Student to R1
A
举一反三
- 使角色R1 减少 SELECT 权限的语句是 A: REVOKE SELECT ON TABLE Student FROM R1 B: REVOKE SELECT ON TABLE Student TO R1 C: GRANT SELECT ON TABLE Student FROM R1 D: GRANT SELECT ON TABLE Student TO R1
- 将查询和修改Student表的权限授给用户U4的SQL语句是(<br/>)。 A: GRANT<br/>SELECT, UPDATE ON TABLE Student TO U4 B: REVOKE<br/>SELECT, UPDATE ON TABLE Student FROM U4 C: GRANT<br/>SELECT ON TABLE Student TO U4 D: REVOKE<br/>UPDATE ON TABLE Student FROM U4
- 使角色R1减少SELECT权限的语句是( )。 A: REVOKE<br/>SELECT ON TABLE Student FROM R1
- 将查询Student表和修改学生学号的权限授给用户U4。实现此功能的SQL语句是(<br/>)。 A: GRANT UPDATE(Sno),SELECT<br/>ON TABLE Student TO U4 ; B: GRANT UPDATE,SELECT<br/>ON TABLE Student TO U4 ; C: GRANT SELECT ON TABLE<br/>Student TO U4 ; D: GRANT UPDATE ON TABLE<br/>Student TO U4 ;
- 给xiaowang的用户分配对数据库course 中的student表的查询、更新和插入数据权限的语句是_______。 A: grant select,update,insert on course.student for ‘xiaowang@localhost’; B: grant select,update,insert on course.student to ‘xiaowang@localhost’; C: grant ‘xiaowang@localhost’ to select,update,insert for course.student; D: grant ‘xiaowang@localhost’ to course.student on select,update,insert;
内容
- 0
使角色 R1 在原来的基础上增加 Student 表的 DELETE 权限的语句是 A: GRANT DELETE ON TABLE Student FROM R1 B: GRANT DELETE ON TABLE Student TO R1 C: REVOKE DELETE ON TABLE Student FROM R1 D: REVOKE DELETE ON TABLE Student TO R1
- 1
收回所有用户对基本表STUDENT的UPDATE操作权限可由_____语句完成。 A: REVOKE UPDATE ON TABLE STUDENT FROM WANG B: REVOKE UPDATE ON STUDENT FROM WANG C: GRANT UPDATE ON STUDENT TO PUBLIC D: REVOKE UPDATE ON TABLE STUDENT FROM PUBLIC
- 2
SQL SERVER系统的触发器包括( ) A: select、insert、delete B: insert、delete、update C: select、insert、update D: select、delete、update
- 3
SQL Server触发器主要针对下列语句创建（）。 A: SELECT、INSERT、DELETE B: INSERT、UPDATE、DELETE C: SELECT、UPDATE、INSERT D: INSERT、UPDATE、CREATE
- 4
查询数据表中记录的SQL语句是（ ）。? INSERT|CREATE TABLE|SELECT|UPDATE