—Whereis_______mathsteacher?—He’stalkingwithSam’sf-X题卡

设有关系模式studentsnosnameagedept现利用命令CREATEVIEWstuASSE

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths" WHERE age＞=20 INSERT INTO stu VALUES("2004001"，"John"，30，"cs") INSFRT INTO stu VALUES("2004001"，"John"，50，"maths")

设有关系模式studentsnosnameagedept现利用命令CREATEVIEWstuASSE

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths" WHERE age＞=20 INSERT INTO stu VALUES("2004001","John",30,"cs") INSERT INTO stu VALUES("2004001","John",50,"maths")

查询选修了课程号为MATHS的学生的姓名和年龄若用下列SQL的SELECT语句表达时错误的是

SEIECT SNAME, ADE FROM S WHERE S#=(SELECT S S# FROM SC WHERE C#='MATHS') SELECT SNAME, AGE FROM S WHERE S#=(SELECT S S# FROM SC WHERE S C#='MATHS') SELECT SNAME, AGE FROM S, SC WHERE S#=SS# AND S C#='MATHS' ORDER BY S# SELECT SNAME, AGE FROMS, SC WHERE S#=SS# AND SC#='MATHS'

设有关系模式studentsnosameagedept现利用命令CREATEVIEWstuASSEL

UPDATE stu SET dept=“maths” UPDATE stu SET dept=“maths”WHEREage>=20 INSERT INTO stu VALUES(“2004001”，“John”，30，“cs”) INSERT INTO stu VALUES(“2004001”，“John”，50，“maths”)

设有关系模式studentsnosnameagedept现利用命令CREATEVIEWstuASSE

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths" WHERE age＞=20 INSERT INTO stu VALUES("2004001","John",30,"cs") INSERT INTO stu VALUES("2004001","John",50,"maths")

---Andwhere’smymathsbook?---It’sthetablE.

under on to behind

Wherewasit______you_______ourmathsteacher?

where; came to that; come across, that; came across where; come to

Wherewasit______you_______ourmathsteacher?

where; came to that; come across, that; came across where;come to

设有关系模式studentsnosnameagedept现利用命令CREATEVIEWstuASSE

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths" WHERE age＞=20 INSERT INTO stu VALUES("2004001","John",30,"cs") INSERT INTO stu VALUES("2004001","John",50,"maths")

设有关系模式studentsnosnameagedept现利用命令 CREATEVIEWstuAS

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths"WHERE age＞=20 INSERT INTO stu VALUES ("2004001", "John", 30, "cs") INSERT INTO stu VALUES ("2004001", "John", 50, "maths")

Idon’tknow______todowiththemathsproblem.It’stoohar

which 　 how 　 what 　 where

Afterworkingonthemathsproblemforhourshefound______

what that where which

设有关系模式studentsnosnameagedept现利用命令 CREATEVIEWstuAS

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths"WHERE age＞=20 INSERT INTO stu VALUES ("2004001", "John", 30, "cs") INSERT INTO stu VALUES ("2004001", "John", 50, "maths")

查询选修了课程号为MATHS的学生的姓名和年龄若用下列SQL的SELECT语句表达时错误的是

SELECT SNAME,AGE FROM S WHERE S.S#=(SELECT SC.S#FROM SC WHERE C.C#='MATHS') SELECT SNAME,AGEFROM SWHERE S.S#=(SELECT SC.S#FROM SC WHERE SC.C#='MATHS') SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS' ORDER BY S.S# SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS'

Isitthedays__________youstudiedinourschool________

that, where that, that when, where when , that

设有关系模式studentsnosnameagedept现利用命令CREATEVIEWstuASSE

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths" WHERE age＞=20 INSERT INTO stu VALUES("2004001"，"John"，30，"cs") INSFRT INTO stu VALUES("2004001"，"John"，50，"maths")

—YouseeI.’mpoorinmathsyouarenotgoodatEnglishanD.—T

when where how what

Theman______isstandingontheplaygroundismymathsteac

when which who where

设有关系模式studentsnosnameagedept现利用命令CREATEVIEWstuASSE

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths"WHERE age＞=20 INSERT INTO stu VALUES("2004001"，"John"，30，"CS") INSERT INTO stu VALUES("200400l","John"，50，"maths")

设有关系模式studentsnosnameagedept现利用命令CREATEVIEWstuASSE

UPDATE stu SET dept="maths" UPDATE stu SET dept="maths"WHERE age＞=20 INSERT INTO stu VALUES ("2004001", "John", 30, "cs") INSERT INTO stu VALUES ("2004001", "John", 50, "maths")

— Where is _______ maths teacher? — He’s talking with Sam’s father.

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库