单选题Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）A SORT BY age ASC, last_name
题目
SORT BY age ASC, last_name
SORT BY age DESC, last_name
ORDER BY age DESC, last_name
ORDER BY age ASC, last_name
相似考题
更多“单选题Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）A SORT BY age ASC, last_nameB”相关问题
-
第1题：
检索所有比"王华"年龄大的学生姓名、年龄和性别。正确的SELECT语句是()A、SELECT SN，AGE，SEX FROM S
SHERE AGE>(SELECT AGE FROM S)
WHERE SN=’王华’)
B、SELECT SN，AGE，SEX
FROM S
WHERE SN=’王华’
C、SELECT SN，ACE，SEX FROM S
WHERE AGE>(SELECT ACE
WHERE SN=’王华’)
D、SELECT SN，ACE，SEX FROM S
WHERE ACE>王华AGE
参考答案：A
-
第2题：
根据SQL标准，下面哪句语句能够找出年龄最小的同学?其中age为学生表student中的年龄字段，sno为学生的学号。()
A select max(age) from student
B select sno from student where age = max(age)
C select sno from student having age = max(age)
D select sno from student a where a.age<= (select min(b.age) from student b)
参考答案D -
第3题：
根据SQL标准，要查询表student中所有年龄age小于所有学生的平均年龄的记录，下面哪条语句适用?()
A select * from student where age< avg(age)
B select * from student having age< avg(age)
C select * from student a where a.age< (select avg(b.age) from student b)
D select * from student a where (select avg(b.age) from student b ) >= a.age
参考答案C -
第4题：
查询所有目前年龄是22岁的学生信息：学号，姓名和年龄，正确的命令组是( )。
A．CREATE VIEW AGE LIST AS； SELECT 学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT 学号，姓名，年龄FROM AGE LIST WHERE年龄=22
B．CREATE VIEW AGE LIST AS； SELECT 学号，姓名，YEAR(出生日期) FROM 学生； SELECT 学号，姓名，年龄FROM AGE LIST WHERE YEAR(出生日期)=22
C．CREATE VIEW AGE LIST AS； SELECT 学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT 学号，姓名，年龄FROM学生WHEREYEAR(出生日期)=22
D．CREATE VIEW AGE LIST AS STUDENT； SELECT学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM STUDENT WHERE年龄=22
正确答案：A
解析：选项B和选项C是从建立的AGE LIST视图中查询数据，但AGE LIST视图中没有出生日期字段。选项D是从STUDENT表或视图中查询数据，但是STUDENT表或视图不存在。选项A是正确答案。 -
第5题：
对于学生信息表STUDENT（SNO， SNAME，SEX，AGE，DEPT)（STUDENT由学号SNO、姓名SNAME、性别SEX、年龄AGE、所在系DEPT 5个属性组成，其中SNO为主码），求年龄20～23岁之间的学生姓名和年龄，正确的语句是（ ）。A．SELECT SNAME，AGE FROM STUDENT WHERE AGE>20 AND AGE<23B． SELECT*FROM STUDENT WHERE AGE BETWEEN 20 AND 23C．SELECT SNAME，AGE FROM STUDENT WHERE AGE BETWEEN 20 AND 23D．以上均不正确
正确答案：C
A项在表述年龄的范围时有错误，SQL并不是那样表示的，B项不符题意，查询的结果为学生信息表的所有字段。 -
第6题：
对于数据表：student(sno,sname,sex,age,grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是______。
A．SELECT sno,sname FROM student WHERE gade=NULL
B．SELECT sno,sname FROM student WHERE grade IS NULL
C．SELECT sno,age FROM student WHERE grade IS NULL
D．SELECT mo,age FROM student WHERE grade=NULL
正确答案：B
解析：A、D选项中，不能写成列名=NULL；C、D选项查询的字段不正确。 -
第7题：
查询所有目前年龄是22岁的学生信息：学号，姓名和年龄，正确的命令组是
A．CREATE VIEW AGE_LIST AS； SELECT学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM AGE_LIST WHERE年龄=22
B．CREATE VIEW AGE_LIST AS； SELECT学号，姓名，YEAR(出生日期)FROM学生： SELECT学号，姓名，年龄FROM AGE_LIST WHERE YEAR(出生日期)=22
C．CREATE VIEW AGE_LIST AS； SELECT学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM学生WHERE YEAR(出生日期)=22
D．CREATE VIEW AGE_LIST AS STUDENT； SELECT学号，姓名，YEAR(DATE())．YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM STUDENT WHERE年龄=22
正确答案：A
解析：本题考查SOL中复杂查询语句的书写，四个选项中只有选项A是正确的。选项B和选项C是从建立的AGE_LIST视图中查询数据，但AGE_LIST视图中没有出生日期字段。选项D是从STUDENT表或视图中查询数据，但是 STUDENT表或视图不存在。故选项A是正确答案。 -
第8题：
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）
- A、SORT BY age ASC, last_name
- B、SORT BY age DESC, last_name
- C、ORDER BY age DESC, last_name
- D、ORDER BY age ASC, last_name
正确答案:C -
第9题：
对于学生信息表（XSB），包含字段：学号（SNO），姓名（SNAME），性别（SEX），年龄（AGE），所在系（DEPT），其中SNO为主码，检索年龄在20~30之间的学生姓名和年龄，正确的语句是（）
- A、select sname，age from xsb where age>20and age<23
- B、select*from xsb where age between20 and 23
- C、select sname，age from xsb where agebetween20 and 23
正确答案:C -
第10题：
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）
- A、UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
- B、UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
- C、UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
- D、UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;
正确答案:D -
第11题：
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）AUPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
BUPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
CUPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
DUPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
正确答案： D解析： 暂无解析 -
第12题：
单选题Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）ASORT BY age ASC, last_name
BSORT BY age DESC, last_name
CORDER BY age DESC, last_name
DORDER BY age ASC, last_name
正确答案： B解析： 暂无解析 -
第13题：
根据SQL标准，要查询表student中平均年龄age小于21的所在系dept及其平均年龄值，下面哪条语句适用?()
A select dept,avg(age) from student where avg(age)<21
B select dept,avg(age) from student group by dept having avg(age)<21
C select dept,avg(age) from student having avg(age)<21
D select dept,avg(age) from student group by dept where avg(age)<21
参考答案B
-
第14题：
根据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.age<= any (select distinctb.age from student b)
D select distinct a.age from student a where a.age<= all (select distinct b.age from student b)
参考答案D -
第15题：
S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。
A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝'王华')
B．SELECT SN, AGE, SEX FROM S WHERE SN='王华'
C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝'王华')
D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华AGE
正确答案：A
解析：选项B查询的结果是显示出姓名为王华的学生姓名、年龄、和性别。
选项C在嵌套的SELECT语句中缺少必要的短语FROM。
选项D格式不正确。 -
第16题：
S(S,SN,SEX,AGE,DEPT)C(C,CN)SC(S,C,GRADE)其中:S为学号,SN为姓名,SEX为性别,AGE为年龄,DEPS(S#,SN,SEX,AGE,DEPT) C(C#,CＮ) SC(S#,C#,GRADＥ) 其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。 正确的SELECT语句是______。
A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝‘王华’)
B．SELECT SN,AGE,SEX FROM S WHERE SN＝‘王华’
C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝‘王华’)
D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华 AGE
正确答案：A
解析：选项B查询的结果是显示出姓名为王华的学生姓名、年龄、和性别。选项C在嵌套的SELECT语句中缺少必要的短语FROM。选项D格式不正确。 -
第17题：
若要求查找“年龄大于18岁学生的学生号和姓名”，正确的SQL语句是( )。
A．SELECT S#，SNAME FROM S WHERE AGE>18
B．SELECT S#，SNAME FROM S WHERE AGE>=18
C．SELECT S#，SNAME FROM S WHERE AGE>'18'
D．SELECT S#，SNAME FROM S WHERE AGE>='18'
正确答案：A
解析：要查询“学生号和姓名”，主句为SELECTS#，SNAMEFROMS。“年龄”属性应当属于数值型，要表达“年龄大于18岁”，则条件子句为WHEREAGE>18。 -
第18题：
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age >40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）
A.SORT BY age ASC, last_name
B.SORT BY age DESC, last_name
C.ORDER BY age DESC, last_name
D.ORDER BY age ASC, last_name
参考答案：C
-
第19题：
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。
A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN='王华')
B．SELECT SN,AGE,SEX FROM S WHERE SN='王华'
C．SELECT SN,AGE, SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN='王华')
D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华 AGE
正确答案：A
-
第20题：
下列SQL语句中，能够完成求某列最大值的是（）。
- A、SELECT AVG（Age） FROM Student
- B、SELECT MAX（Age） FROM Student
- C、SELECT MIN（Age） FROM Student
- D、SELECT COUNT（*） FROM Student
正确答案:B -
第21题：
数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据，下列哪个SQL语句是正确的？（）
- A、Select* From Student Where Age>=20 ANDAge>=30
- B、Select* From Student Where Age>=20 ANDAge<=30
- C、Select* From Student Where Age BET WENN 20AND30
- D、Select* From Student Where Age>=20&&Age>=30"
正确答案:A,C -
第22题：
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）
- A、UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
- B、UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
- C、UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
- D、UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
正确答案:D -
第23题：
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid?（）AUPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
BUPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
CUPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
DUPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
正确答案： C解析： 暂无解析 -
第24题：
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）AUPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
BUPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
CUPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
DUPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;
正确答案： A解析： 暂无解析