以下触发器,在________情况下不会被触发。 CREATE TRIGGER tri_StudentInsDel ON Student FOR INSERT, UPDATE AS SELECT * FROM StudentA.向Student表添加一个学生王洪的记录B.修改Student表中学生王洪的学号C.修改Student表中学生王洪的姓名D.删除学生表中的姓名为王洪的学生记录
以下触发器,在________情况下不会被触发。 CREATE TRIGGER tri_StudentInsDel ON Student FOR INSERT, UPDATE AS SELECT * FROM Student
A.向Student表添加一个学生王洪的记录
B.修改Student表中学生王洪的学号
C.修改Student表中学生王洪的姓名
D.删除学生表中的姓名为王洪的学生记录
参考答案和解析
C
相关考题:
使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:A)SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”B)SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”C)SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”D)SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”
设有关系模式:student(sno, sname, age, dept),现利用命令: CREATE VIEW stu AS SELECT *FROM student WHERE dept="cs"WITH CHECK OPTION 创建了一个视图。则以下SQl命令中能正确执行的是A.UPDATE stu SET dept="maths"B.UPDATE stu SET dept="maths"WHERE age>=20C.INSERT INTO stu VALUES ("2004001", "John", 30, "cs")D.INSERT INTO stu VALUES ("2004001", "John", 50, "maths")
The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? ()A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
根据SQL标准,创建一个视图abc,通过该视图只能对表student中系dept为‘IS’的记录进行更新操作。下面哪条语句适用?()A create view abc as select * from student where dept=’IS’B create view abc as select * from student where dept=’IS’ with check optionC create view abc as student where dept=’IS’D create view abc as select dept=’IS’ from student
根据SQL标准,下面哪条语句与select min(age) from student等效?()A select age from student where age >= min(age)B select distinct age from student where age >= all min(age)C select distinct a.age from student a where a.ageD select distinct a.age from student a where a.age
根据SQL标准,要查询表student中所有年龄age小于所有学生的平均年龄的记录,下面哪条语句适用?()A select * from student where ageB select * from student having ageC select * from student a where a.ageD select * from student a where (select avg(b.age) from student b ) >= a.age
查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是A.SELECT sname FROM student,SELECT cno,grade FROM sc WHERE student.sno=sc.snoB.SELECT sname,cno,grade FROM student,course WHERE student.sno=course.cnoC.SELECT sname,cname,grade FROM student,course,sc WHERE student.sno=sc.sno and sc.cno=course,cnoD.SELECT sname,cno,grade FROM student,sc WHERE student.sno=sc.sno
SQL Server2005触发器主要针对下列语句创建()。A.SELECT、INSERT、DELETEB.INSERT、UPDATE、DELETEC.SELECT、UPDATE、INSERTD.INSERT、UPDATE、CREATE
已知有关系“STUDENT”,则关系运算σANE<80(STUDENT)用SQL语句表示为(52)。A.SELECT( * )FROM STUDENT WHERE AVE < 80B.SELECT( * )FROM STUDENT HAVING AVE < 80C.SELECT(AVE)FROM STUDENT WHERE AVE < 80D.SELECT(AVE) FROM STUDENT HAVING AVE < 80
设有关系模式:student(sno,sname,age,dept),现利用命令: CREATE VIEW stu AS SELECT * FROM student WHERE dept="cs"WITH CHECK OPTION创建了一个视图。则以下SQL命令中能正确执行的是( )。A.UPDATE stu SET dept="maths"B.UPDATE stu SET dept="maths"WHERE age>=20C.INSERT INTO stu VALUES("2004001","John",30,"CS")D.INSERT INTO stu VALUES("200400l","John",50,"maths")
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? ()A、SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D、SELECT student_id, gpa FROM student_grades ORDER BY gpa;E、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F、SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?()A、MANAGER must be a role.B、It allows the MANAGER to pass the specified privileges on to other users.C、It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D、It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E、It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F、It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
查询student表中的所有非空email信息,以下语句正确的是()。A、Select email from student where email !=nullB、Select email from student where email not is nullC、Select email from student where email nullD、Select email from student where email is not null
下列查询年龄最大的前四个学生(包括并列的情况)的语句,正确的是()。A、SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage ASCB、SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage ASCC、SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage DESCD、SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage DESC
SQL Server触发器主要针对下列语句创建()。A、SELECT、INSERT、DELETEB、INSERT、UPDATE、DELETEC、SELECT、UPDATE、INSERTD、INSERT、UPDATE、CREATE
数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?()A、Select* From Student Where Sex=’男’B、Select* From Student Where Number NotIn(Select Number From Student Where Sex=’男’)C、Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’)D、Select* From Student Where Sex’男’
以下触发器是当对[employee表]进行()操作时触发。Create Trigger abc on employeeFor insert,update,deleteAs⋯⋯A、只是修改B、只是插入C、只是删除D、修改、插入、删除
SQL Server2005触发器主要针对下列语句创建()。A、SELECT、INSERT、DELETEB、INSERT、UPDATE、DELETEC、SELECT、UPDATE、INSERTD、INSERT、UPDATE、CREATE
查询student表中的所有非空email信息,以下语句正确的是()A、Select email from student where email!=nullB、Select email from student where emailnotisnullC、Select email from student where emailnullD、Select email from student where emailisnotnull
在Transact-SQL语法中,以下SELECT语句正确的是()。A、SELECT * FROM studentB、SELECT * FROM student WHERE GETDATE()C、SELECT * FROM student ORDER st_idD、SELECT * FROM student BY St_name
单选题SQL Server2005触发器主要针对下列语句创建()。ASELECT、INSERT、DELETEBINSERT、UPDATE、DELETECSELECT、UPDATE、INSERTDINSERT、UPDATE、CREATE
单选题SQL Server触发器主要针对下列语句创建()。ASELECT、INSERT、DELETEBINSERT、UPDATE、DELETECSELECT、UPDATE、INSERTDINSERT、UPDATE、CREATE
单选题You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.Which statement accomplishes this?()AGRANT select, insert, update ON student_grades TO managerBGRANT select, insert, update ON student_grades TO ROLE managerCGRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;DGRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;EGRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;FGRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
单选题以下触发器是当对[employee表]进行()操作时触发。Create Trigger abc on employeeFor insert,update,deleteAs⋯⋯A只是修改B只是插入C只是删除D修改、插入、删除
多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?()AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.FIt allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.