The population between the age of 25 and 44 increased by 28.1%from 1980 to 1989 because()
第1题:
The period of Stone Age is during 2000--250BC.()
第2题:
根据SQL标准,要修改表student中所有学生的年龄age,使之在原值基础上减一,下面哪个语句适用?()
A update student set age = 1
B update student set age = age - 1
C update age = age -1 from student
D update from student where age = age -1
第3题:
根据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)
第4题:
与WHERE AGE BETWEEN 18 AND 23完全等价的是( )。
A.WHERE AGE>18AND AGE
B.WHERE AGE>=18AND AGE
C.WHERE AGE>18AND AGE
D.WHERE AGE>=18AND AGE
第5题:
第6题:
第7题:
第8题:
A major source of population growth is()
第9题:
与WHERE AGE BETWEEN 18 AND 23完全等价的是()
第10题:
California Lawmakers Vote to Raise Smoking Age to 21
San Francisco Increased the Age to Buy Tobacco Products to 21
Hawaii Has Already Raised the Age Limit to Buy Tobacco
A California Bill Faces Opposition from Many Republicans
第11题:
第12题:
在数据库查询语句中,“age between 30 and 40”等同于( ) (1.0分) [单选.]
A. age>=30 or age<=40 B. age>=30 and age<=40 C. age>30 and age<40 D. age>30 or age<40
答案: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
第14题:
根据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)
第15题:
对于学生信息表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.以上均不正确
第16题:
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的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
第17题:
第18题:
第19题:
The population between the age of 25 and 44 increased by 28.1%from 1980 to 1989 because()
Athis was the period of large inflow of young immigrants
Bthis was the birth age of the baby boomers.
Cthe large number born during WW II reached this age bracket
Dthose who were born in the period of baby boom reached this age bracket
第20题:
对于学生信息表(XSB),包含字段:学号(SNO),姓名(SNAME),性别(SEX),年龄(AGE),所在系(DEPT),其中SNO为主码,检索年龄在20~30之间的学生姓名和年龄,正确的语句是()
第21题:
You are building a dating web site. The client’s date of birth is collected along with lots of other information.The Person class has a derived method, getAge():int, which returns the person’s age calculated from thedate of birth and today’s date. In one of your JSPs you need to print a special message to clients within theage group of 25 through 35. Which two EL code snippets will return true for this condition? ()
第22题:
${client.age in [25,35]}
${client.age between [25,35]}
${client.age between 25 and 35}
${client.age <= 35 && client.age >= 25}
${client.age le 35 and client.age ge 25}
第23题:
this was the period of large inflow of young immigrants
this was the birth age of the baby boomers.
the large number born during WW II reached this age bracket
those who were born in the period of baby boom reached this age bracket