数据库SQL语言中,AGE IN(15,35)短语的正确含义是(14)。
A.AGE=15AND AGE=35
B.AGE=15 OR AGE=35
C.AGE<=35 AND AGE>=15
D.AGE<35 AND AGE>15
第1题:
根据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
第2题:
如果要在SPSS数据中选择出年龄(age)在18-60岁的所有个案,则下列哪个条件表达式是正确的?【 】
A.age>=18 & age<=60
B.age>=18 | age<=60
C.18<= age <=60
D.age>=18 & <=60
第3题:
16、要求男生(SEX=‘M’)年龄(AGE)在15到60之间,女生(SEX=‘F’)年龄在15到55之间,则正确的约束检查语句是()。
A.CHECK(age>=15 AND ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))
B.CHECK(age>=15 AND ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))
C.CHECK(age>=15 OR ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))
D.CHECK(age>=15 OR ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))
第4题:
要求男生(SEX=‘M’)年龄(AGE)在15到60之间,女生(SEX=‘F’)年龄在15到55之间,则正确的约束检查语句是()。
A.CHECK(AGE>=15 AND ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))
B.CHECK(AGE>=15 AND ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))
C.CHECK(AGE>=15 OR ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))
D.CHECK(AGE>=15 OR ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))
第5题:
16、下面哪一个表达式能正确表示逻辑关系:"age≥18 或age≤60"?
A.age>=18 or age<=60
B.age>=18 | age<=60
C.age>=18 && age<=60
D.age>=18 || age<=60