修改触发器Update_Student_Trigger。在确实修改了Student表中的数据后显示“已修改Student表的数据。”，否则显示“不存在要修改的数据。” USE XkGOALTER TRIGGER Update_Student_Trigger /*修改已创建的触发器。*/______ Student______ UPDATEAS IF((SELECT COUNT(*) FROM inserted) ______) PRINT '已修改Student表的数据。' ELSE PRINT '不存在要修改的数据。' A:

收回所有用户对基本表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

授予用户Mary可以修改Student表的权限,使用的SQL语句是( )。 A: GRANT UPDATE ON<br/>Student TO Mary B: GRANT UPDATE ON<br/>Mary TO Student C: GRANT UPDATE TO<br/>Mary ON Student D: GRANT UPDATE TO<br/>Student ON Mary

使角色 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

将STUDENT、表中NL列的值都更新为20岁，正确的SQL语句是______ A: UPDATE STUDENT SET NL=21 B: SET STUDENT UPDATE NL=20 C: UPDATE STUDENT SET NL=20 D: INSERT INTO STUDENT SET NL=20

下列SQL语句中,能够实现“收回用户user1对学生表中学号的修改权限”的是( )。 A: REVOKE UPDATE on student(sno) from ALL B: REVOKE UPDATE on student(sno) from user1 C: REVOKE UPDATE(sno) on student from user1 D: REVOKE UPDATE(sno) on student from PUBLIC

把student表中id字段值小于3的记录，将这些记录的grade字段值都更新为100（） A: UPDATE FROM student SET grade=100 where id<;3 B: UPDATE student SET grade=100 where id<;3 C: UPDATE student SET grade=100 D: UPDATE INTO student SET grade=100 where id<;3

将STUDENT表中所有学生年龄AGE字段值增加1岁,应使用命令( ). A: REPLACE AGE WITH AGE+1 B: UPDATE SET AGE WITH AGE+1 C: UPDATE STUDENT AGE WITH AGE+1 D: UPDATE STUDENT SET AGE=AGE+1

将所有计算机系学生的年龄增加1岁的正确语句是：（ ）。 A: UPDATE SET Student.Sage = Student .Sage + 1 WHERE Student.Sdept = 'CS'; B: UPDATE Student SET Sage + 1 WHERE Sdept = 'CS'; C: UPDATE Student SET Sage =Sage + 1 WHERE Sdept = 'CS'; D: UPDATE Student SET Sage += 1 WHERE Sdept = 'CS';

将查询和修改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