[第4章数据操作语句.docxVIP

第 4 章 数据操作语句选择题当关系R和S进行连接操作时，如果R中的元组不满足连接条件，在连接结果中也会将这些记录保留下来的操作是AA．左外连接B．右外连接C．内连接D．自连接设在某SELECT语句的WHERE子句中，需要对Grade列的空值进行处理。下列关于空值的操作，错误的是CA．Grade IS NOT NULLB．Grade IS NULLC．Grade =NULLD．NOT (Grade IS NULL)下列聚合函数中，不忽略空值的是DA．SUM(列名) B．MAX(列名)C．AVG(列名)D．COUNT(*)4．SELECT … INTO …FROM语句的功能是A将查询结果插入到一个新表中将查询结果插入到一个已建好的表中合并查询的结果向已存在的表中添加数据5．下列利用SC表的查询语句中，错误的是BSELECT Sno, COUNT(*) FROM SC GROUP BY SnoSELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*) 3SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*) 3SELECT Sno FROM SC GROUP BY Sno6．现要利用Student表查询年龄最小的学生姓名和年龄。下列实现此功能的查询语句中，正确的是DSELECT Sname, MIN(Sage) FROM StudentSELECT Sname, Sage FROM Student WHERE Sage = MIN(Sage)SELECT TOP 1 Sname, Sage FROM Student SELECT TOP 1 Sname, Sage FROM Student ORDER BY Sage7．设SC表中记录成绩的列为：Grade，类型为int。若在查询成绩时，希望将成绩按‘优’、‘良’、‘中’、‘及格’和‘不及格’形式显示，正确的Case函数是CCase GradeWhen 90~100 THEN 优When 80~89 THEN 良When 70~79 THEN 中When 60~69 THEN 及格Else 不及格EndCase When Grade between 90 and 100 THEN Grade = 优When Grade between 80 and 89 THEN Grade = 良When Grade between 70 and 79 THEN Grade = 中When Grade between 60 and 69 THEN Grade = 及格Else Grade = 不及格EndCase When Grade between 90 and 100 THEN 优When Grade between 80 and 89 THEN 良When Grade between 70 and 79 THEN 中When Grade between 60 and 69 THEN 及格Else 不及格EndCase GradeWhen 90~100 THEN Grade = 优When 80~89 THEN Grade = 良When 70~79 THEN Grade = 中When 60~69 THEN Grade = 及格Else Grade = 不及格End8．下述语句的功能是将两个查询结果合并为一个结果。其中正确的是BA．select sno,sname,sage from student where sdept = csOrder by sage Unionselect sno,sname,sage from student where sdept = is Order by sage B．select sno,sname,sage from student where sdept = cs Unionselect sno,sname,sage from student where sdept = isOrder by sageC．select sno,sname,sage from student where sdept = cs Unionselect sno,sname from student where sdept = isOrder by sageD．select sno,sname,sage from student where sdept = cs Order by sage Unionselect sno,sname,sage from student where sd