A.首部
B.案由
C.违约责任
D.副本
第1题
设有学生表S(学号,姓名,性别,年龄),查询所有年龄小于等于18岁的女同学、并按年龄进行降序排序生成新的表WS,正确的SQL命令是______。
A.SELECT * FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY 4 DESC INTO TABLE WS
B.SELECT * FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY 年龄 INTO TABLE WS
C.SELECT * FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY '年龄' DESC INTO TABLE WS
D.SELECT * FROM S WHERE 性别='女' OR 年龄<=18 ORDER BY '年龄' ASC INTO TABLE WS
第2题
设有学生表S(学号,姓名,性别,年龄),查询所有年龄小于等于18岁的女同学、并按年龄进行降序排序生成新的表WS,正确的SQL命令是______。
A.SELECT * FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY 4 DESC INTO TABLE WS
B.SELECT * FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY 年龄 INTO TABLE WS
C.SELECT * FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY '年龄' DESC INTO TABLE WS
D.SELECT * FROM S WHERE 性别='女' OR 年龄<=18 ORDER BY '年龄' ASC INTO TABLE WS
第3题
设有学生表S(学号,姓名,性别,年龄),查询所有年龄小于等于18岁的女同学、并按年龄进行降序排序生成新的表WS,正确的SQL命令是()。
A.SELECT* FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY 4 DESC INTO TABLE WS
B.SELECT* FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY 年龄 INTO TABLE WS
C.SELECT* FROM S WHERE 性别='女' AND 年龄<=18 ORDER BY '年龄' DESC INTO TABLE WS
D.SELECT* FROM S WHERE 性别='女' OR 年龄<=18 ORDER BY '年龄' ASC INTO TABLE WS
第4题
设有学生表 S(学号 , 姓名 , 性别 , 年龄 ) ,查询所有年龄小于等于 18 岁的女同学,并按年龄进行降序排序生成新的表 WS ,正确的 SQL 命令是
A) SELECT * FROM S WHERE 性别 =' 女 ' AND 年龄 <=18 ORDER BY 4 DESC INTO TABLE WS
B) SELECT * FROM S WHERE 性别 =' 女 ' AND 年龄 <=18 ORDER BY 年龄 INTO TABLE WS
C) SELECT * FROM S WHERE 性别 =' 女 ' AND 年龄 <=18 ORDER BY ' 年龄 ' DESC INTO TABLE WS
D) SELECT * FROM S WHERE 性别 =' 女 ' OR 年龄 <=18 ORDER BY ' 年龄 ' ASC INTO TABLE WS
第5题
设有学生表S(学号,姓名,性别,年龄),查询所有年龄小于等于18岁的女同学,并按年龄进行降序生成新的表WS,正确的SQL命令是( )。
A.SELECT*FROM S
WHERE 性别="女"AND 年龄<=18 ORDER BY 4 DESC INTO TABLE WS
B.SELECT*FROM S
WHERE 性别="女"AND 年龄<=18 ORDER BY 年龄 INTO TABLE WS
C.SELECT*FROM S
WHERE 性别="女"AND 年龄<=18 ORDER BY"年龄"DESC INTO TABLE WS
D.SELECT*FROM S
WHERE 性别="女"OR 年龄<=18 ORDER BY"年龄"ASC INTO TABLE WS
第6题
A.SELECT*FROM SWHERE性别=’女’ AND年龄<=18 0RDER BY 4 DESC INTOTABLE WS
B.SELECT*FROM SWHERE性别=’女’AND年龄<=18 0RDER BY 年龄INTO TABLE WS
C.SELECT*FROM SWHERE性别=’女’AND年龄<=18 0RDER BY 年龄DESC INTO TABLE WS
D.SELECT*FROM SWHERE性别=’女’0R 年龄<=18 0RDER BY ’年 龄’ASC INTO TABLE WS
第7题
A.CREATE TABLE stud AS SELECT * FROM student WHERE 性别=女 AND 年龄<=18 ORDER BY 年龄 DESC;
B.CREATE TABLE stud AS SELECT * FROM student WHERE 性别=女 AND 年龄<=18 ORDER BY 年龄 DESC;
C.CREATE TABLE stud AS SELECT * FROM student WHERE 性别=女 AND 年龄<=18 ORDER BY 年龄 ASC;
D.CREATE TABLE stud AS SELECT * FROM student WHERE 性别=女 AND 年龄<=18 ORDER BY 年龄;
第8题
设有关系表学生S(学号,姓名,性别,年龄,身份证号),每个学生学号唯一。除属性学号外,也可以作为键的是()。
A.姓名
B.身份证号
C.姓名,性别,年龄
D.学号,姓名
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!