我的课题练习sql进阶复习试卷答案

1、HAVING 字句中应后跟（B 数据定义语言的缩写词为（ A 在SQL 语言中，建过令为A CREATERULE CREATECREATESQL 令为C HAVING 字句中应后跟（B 数据定义语言的缩写词为（ A 在SQL 语言中，建过令为A CREATERULE CREATECREATESQL 令为C CREATE SQL 的视图的数据是从（A ）A. Select * from Select * from Select*from where 价格where 价格(select*from where 产品名称纸杯whereexists (产品名称纸杯from where 产品名称Selec

2、t * from where 价格(select orders的订单信息，cid ，money Selectcid,count(distinct(cid),sum(money)fromordersorderbycid Select cid count(cid),sum(money) from orders order by cidSelectcidcount(cid),sum(money)fromordersgroupby实体关系中学生与任课教师之间具有（D ）SQL （C ）在CREATE VIEW ）DECLAREpwdpwd VARCHAR(10)pwd在CREATE VIEW ）DEC

3、LAREpwdpwd VARCHAR(10)pwdE-R 图中，关系用下面（C ）T-SQL中用户自定义的变量是（B 在数据库中查询数据，一般根据（C ）分析下面的代码段，说法错误的是（D （选择一项） 1 CREATE PROCEDURE proc_stuInfo2stuName3 8 11EXEC proc_stuInfo ，n=s41011过程，以下说法正确的是（ A A. B. T-SQLpric（float以下语句正确的是（BC （选两项Selecttop1*frombookorderbypriceSelecttop1*frombookorderbypriceSelecttop1*p

4、ric（float以下语句正确的是（BC （选两项Selecttop1*frombookorderbypriceSelecttop1*frombookorderbypriceSelecttop1*frombookwhereprice=(selectmax(price)frombook) Select top1 * from book where price=max(price) ，可以执行以下）sql 语句（选一项A)Selectdistinct(cid)fromorderso1whereSelectdistinct(cid)fromorderso1whereSelectdistinct(ci

5、d)fromorderso1wherein=P01and=P01andect*fromd=P02andSelectdistinct(cid)fromorderso1,orderso2where=P01andT-SQL代码运行完的结果是（C declarecounter set counter=1 222createview 对以上语句描述不正确的是（ B C. D. select*fromview_stuInfostuInfoIfnotexists(select*fromstuMarkswhereorUpdatestuMarksset以上语句的功能是（ D 21. create proc My

6、Proc IfmystuIDis没有传递任何参数以上语句的功能是（ D 21. create proc MyProc IfmystuIDis没有传递任何参数select*fromstudentwherestuid=mystuid exec执行上面得到语句输出正确的是（D （选择一项B、调过程 myproc 出现错 distri_num(经销商 )）为 select*fromdistributorswhereselectcity_codefromdistributorsB、select*fromdistributorsC、select*fromdistributorswhereselects_n

7、amefromdistributorsD、select*fromdistributorswherecity_codeselectcity_codefromdistributorsStudent(StuID 学学生成,StuAge)Score(StuID 学现要求查询JAVA绩好的学生信息（C A、Select*fromstudentwhereB、select*fromstudentwherestuidselectstuidfromscorewhereSubject=javaandA、Select*fromstudentwhereB、select*fromstudentwherestuidsel

8、ectstuidfromscorewhereSubject=javaandmarks(selectmarksfromscoreC、select*fromstudentwherestuidselectstuidfromscorewhereSubject=javaandmarks(selectmarksfromscoresubject=javaandstuid=(selectstuidfromstudentwhere Dselect*fromstudentwherestuidselectstuidfromscorewhereSubject=javaandmarks(selectmarksfroms

9、corestuid=(selectstuidfromstudentwhere 24. 从“产品”表里查询出价格高于产品名称为“海天酱油”的产品的为（ D）A、SELECT*FROM WHERE 价格SQL B、SELECT * FROM 酱油WHERE 价格(SELECT * FROM C、SELECT*FROM WHEREEXISTS 产品名称=海天酱油D、SELECT * FROM WHERE 价格(SELECT FROM WHERE 产品名称海天酱油 确查询是（AC ）A、SELECTtop1productname,UnitpriceFROMproductsorderbyUniprice

10、B、SELECTproductname,MAX(UnitpriceFROMMAX(Unitprice)FROMD、SELECTproductname,MAX(Unitprice)FROMproductsBy 12345678Select 学号=stuNo,成绩whenwrittenExam60thenwhen writtenExam bet whenwrittenExam bet whenwrittenExam elsen60and69thenn70and79thenn80and89thenfrom下述正确的说法是（A D、第七行end可以27. 分析以下代码，说法正确的是（B （选择一项Se

11、lect * from stuInfo where stuNo not in (select stuNo from stuMarks where writtemExam !=100)27. 分析以下代码，说法正确的是（B （选择一项Select * from stuInfo where stuNo not in (select stuNo from stuMarks where writtemExam !=100)selecttop(1)*fromstuInfowherestNonotin(selecttop(2)stNofrom以上语句的功能是（C ？（ABD （选择三项A、Selectst

12、unamefromstudentwherestuidin(selectstuidfromscore) B、Selectstunamefromstudent,scorewherestudent.stuid=score.stuidC、Selectstunamefromstudentleftouterjoinscoreon 换 （BC（C、Sql server 默认将每条单独的 T-SQl 语句视为一个事务 （AB（Master （BD（A、SELECT ename,job,sal FROM WHERE deptno ALL (SELECT deptno FROM WHEREdnameLIKEB、SELECT ename,job,sal FROM WHEREdnameLIKEC、SELECT ename,job,sal FROM WHEREdnameLIKED、SELECT ename,job,sal B、SELECT ename,job,sal FROM WHEREdnameLIKEC、SELECT ename,job,sal FROM WHEREdnameLIKED、SELECT ename,job,sal F