A.产品成本计算表
B.工资分配表
C.罚款通知书
D.增值税专用发票
第1题
A.SELECT* FROM R WHERE <'2'
B.SELECTB, E FROM R WHERE B<'2'
C.SELECTB, E FROM R HAVING E<'2'
D.SELECT* FROM R WHERE '5'<B
第2题
A.SELECT*FROM R WHERE L<'2'
B.SELECT LJ FROMR WHERE I<'2'
C.SELECT LJ FROMR WHERE J<'2'
D.SELECT* FROMR WHERE '5'<'2'
第3题
A.SELECT A,B FROM R,S WHERE C<B
B.SELECT R.A,S.B FROM R,S WHERE R.C<S.B
C.SELECT 1,5 FROM R WHERE C<(SELECT B FROM S)
D.SELECT A,B FROM RWHERE C<(SELECT B FROM S)
第4题
设有关系R(A,B,C)和S(C,D)。与关系代数表达式πA,B,D(σR.C=S.C(R×S)等价的SQL语句是
A.SELECT*FROM R,S WHERE R.C=S.C
B.SELECT A,B,D FROM R,S WHERE R.C=S.C
C.SELE4T 1,2,8 FROM R,S WHERE R=S
D.SELECT A,B FROM R WHERE(SELECT D FROM S WHERE R.C=S.
第5题
设有关系R(A,B,C)和S(C,D),与关系代数表达式ΠA,B,D(σR,C=S.C(R×S))等价的SQL语句是______。
A.SELECT*FROMR,S WHERE R.C=S.C
B.SELECT A,B,D FROM R,S WHERE R.C=S.C
C.SELECT A,B,D FROM R,S WHERE R=S
D.SELECT A,B FROM R WHERE(SELECT D FROM S WHERE R.C=S.
第6题
下列语句错误的是()
A.select * from orders where ordername is not null;
B.select * from orders where ordername<>null;
C.select * from orders where ordername is null;
D.select * from orders where ordername not is null;
第7题
下列SELECT语句语法正确的是()。
A.SELECT* FROM′teacher′WHERE性别=′男′
B.SELECT*FROM ′teacher′ WHERE性别=男
C.SELECT* FROM teacher WHERE性别=男
D.SELECT* FROM teacher WHERE性别=′男′
第8题
A.SELECTA,B FROM R,SWHERE C<B
B.SELECT R.A,S.B From R,S WHERE R.C<S.B
C.SELECT A,B FROM RWHERE C<(SELECTB FROM S)
D.SELECT 1,5 FROM RWHERE C<(SELECTB FROM S)
第9题
已知有关系模式R(sno,sname,age),其中sno表示学生的学号,类型为Char(8),前4位表示入学年份。查询所有2003年入学的学生姓名(sname),SQL语句是 _______。
A.SELECT sname FROM R WHERE.sno='2003%'
B.SELECT sname FROM R WHERE sno LIKE '2003%'
C.SELECT sname FROM R WHERE sno='2003_'
D.SELECT sname FROM R WHERE sno LIKE '2003_'
第10题
下面SELECT语句语法正确的是()。
A.SELECT*FROM'通信录'WHERE性别='男'
B.SELECT*FROM通信录WHERE性别='男'
C.SELECT*FROM'通信录'WHERE性别=男
D.SELECT*FROM通信录WHERE性别=男
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!