请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.以下（ ）SQL语句可以查询出课程名中只包含“_design”字符串的课程信息。选项： A:select * from course where cname like '%\_design%' escape '\' ; B:select * from course where cname like '%_design%'; C:select * from course where cname like '%*_design%' escape '*'; D:select * from course where cname like '%#_design%' escape '#'
- 2.以下（ ）SQL语句可以查询出课程名中只包含“_design”字符串的课程信息。选项： A:select * from course where cname like '%#_design%' escape '#'; B:select * from course where cname like '%\_design%' escape ''; C:select * from course where cname like '%_design%'; D:select * from course where cname like '%*_design%' escape '*'
- 3.选择题：查询所有名字中包含“数”字的课程信息，可以使用的SQL语句是： 选项： A:SELECT * FROM Course WHERE Cname = '*数*'; B:SELECT * FROM Course WHERE Cname LIKE '*数*'; C:SELECT * FROM Course WHERE Cname LIKE '_数_'; D:SELECT * FROM Course WHERE Cname LIKE '%数%';
- 4.查询所有名字中包含“数”字的课程信息，可以使用的SQL语句是： 选项：A. SELECT * FROM Course WHERE Cname = '*数*';|B. SELECT * FROM Course WHERE Cname = '*数*';|C. SELECT * FROM Course WHERE Cname LIKE '_数_';|SELECT * FROM Course WHERE Cname LIKE '%数%';
- 5.【单选题】选择题：查询所有名字中包含“数”字的课程信息，可以使用的SQL语句是： 选项： A:SELECT * FROM Course WHERE Cname LIKE '*数*'; B:SELECT * FROM Course WHERE Cname LIKE '_数_'; C:SELECT * FROM Course WHERE Cname LIKE '%数%'; D:SELECT * FROM Course WHERE Cname = '*数*';
- 6.以下______SQL语句可以查询出课程名中只包含“C_数据”字符串的课程信息。( ) 选项： A、SELECT * FROM cj_table WHERE CNAME LIKE '%C\_数据%'; B、SELECT * FROM cj_table WHERE CNAME LIKE '%C*_数据%' ESCAPE '*'; C、SELECT * FROM cj_table WHERE CNAME LIKE '%C D、_数据%' ESCAPE ' E、'; F、SELECT * FROM cj_table WHERE CNAME LIKE '%C?_数据%' ESCAPE '?';
- 7. 以下______SQL语句可以查询出课程名中只包含“C_数据”字符串的课程信息。( )选项： A: SELECT * FROM cj_table WHERE CNAME LIKE '%C\_数据%';; B:SELECT * FROM cj_table WHERE CNAME LIKE '%C*_数据%' ESCAPE '*'; ; C:SELECT * FROM cj_table WHERE CNAME LIKE '%C#_数据%' ESCAPE '#'; ; D: SELECT * FROM cj_table WHERE CNAME LIKE '%C?_数据%' ESCAPE '?';
- 8. 以下______SQL语句可以查询出课程名中只包含“C_数据”字符串的课程信息。( )选项： A: SELECT * FROM cj_table WHERE CNAME LIKE '%C\_数据%';; B:SELECT * FROM cj_table WHERE CNAME LIKE '%C*_数据%' ESCAPE '*'; ; C:SELECT * FROM cj_table WHERE CNAME LIKE '%C#_数据%' ESCAPE '#'; ; D: SELECT * FROM cj_table WHERE CNAME LIKE '%C?_数据%' ESCAPE '?';
- 9.有课程表Course (Cno,Cname,Cred),其中:C Cno为课程号,Cname为课程名,Cred为学分。查询 “学分”最高的前两门课,正确的T-SQL语句为( )。 选项： A、SELECT TOP 2 * FROM Course B、SELECT TOP 2 * FROM Course WHERE CRED=MAX(Cred) C、SELECT TOP 2 * FROM Course ORDER BY Cred DESC D、SELECT TOP 2 * FROM Course WHERE CRED=(SELECT MAX(Cred) FROM Course)
- 10.查询选了’数据库原理‘和’java‘的同学姓名select snamefrom student s, sc ,course cwhere s.sno=sc.sno and c.cno=sc.cno and cname='数据库原理' and sno___________________________ 选项： A、 in (select sno from sc join course c on c.cno=sc.cno where cname='JAVA') B、 =(select sno from sc join course c on c.cno=sc.cno where cname='JAVA') C、 in (select sno from sc where cname='JAVA')
- 11.关系代数练习-学生选课（题干）.docx根据附件内容，查询学生所有可能的选课情况，正确的SQL语句是（）。 选项：select sname,cname from student cross join course;#select sname,cname from student join course on student.sno=course.cno;#select sname,cname from student join course join sc on student.sno=sc.sno and sc.cno=course.cno;#select sname,cname from student outer join course;
- 12.下面语句是查询贷款的法人名称，下面哪条语句执行效率最高____。 选项： A:select distinct cname from client c join loan l on c_.cno=l.cno B:select cname from client c where exists(select * from loan l where l.cno=c_.cno) C:select cname from client where cno in(select cno from loan) D:select cname from client where cno not in(select cno from client except select cnoFrom loan)
- 13.对 Course表，使用课程号，课程名，学分，及额外增加的iXueshi字段创建视图，学时为学分乘以16，正确的SQL语句是( )。选项： A:Create View ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course ; B:Create View ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 from Course ; C:Create Proc ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course ; D:Create Index ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course
- 14.设ABC表的A列存储电话号码信息，查询不是以7开头的所有电话号码的查询语句是（ ）。 选项： A、SELECT A FROM ABC WHERE A IS NOT ‘%7’ B、SELECT A FROM ABC WHERE A LIKE ‘%7%’ C、SELECT A FROM ABC WHERE A NOT LIKE ‘7%’ D、SELECT A FROM ABC WHERE A LIKE ‘[1-6]%’
- 15.查询emp表中李姓员工的所有信息（ ）。选项： A:select * from emp where ename is '李% '; B:select * from emp where ename like '李% '; C:select * from emp where ename as '李% '; D:select * from emp where ename not like '李% ';
- 16.查询“图书”表中所有书名以“计算”开头的图书信息，正确的语句是__________。选项： A:SELECT * FROM 图书 WHERE 书名 LIKE "计算?"; B:SELECT * FROM 图书 WHERE 书名 IN "计算*"; C:SELECT * FROM 图书 WHERE 书名 = "计算?"; D:SELECT * FROM 图书 WHERE 书名 LIKE "计算*"
- 17.要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为——选项： A:SELECT * FROM Movie WHERE director LIKE ‘_a_’;; B:SELECT * FROM Movie WHERE director LIKE ‘%a%’;; C:SELECT * FROM Movie WHERE director LIKE ‘%a_’;; D:SELECT * FROM Movie WHERE director LIKE ‘_a%’;
- 18.要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为 A: SELECT * FROM Movie WHERE director LIKE ‘_a_’; B: SELECT * FROM Movie WHERE director LIKE ‘%a%’; C: SELECT * FROM Movie WHERE director LIKE ‘%a_’; D: SELECT * FROM Movie WHERE director LIKE ‘_a%’;
- 19.从Student表检索姓周的学生，对应的SQL语句是( )。选项： A:Select * From Student Where Sname like '周%'; B:Select * From Student Where Sname like '%周'; C:Select * From Student Where Sname like '_周'; D:Select * From Student Where Sname like '周_'
