![](https://static.youtibao.com/asksite/comm/pc/images/content_title_q.png)
用 SQL-Select 语句建立一个基于订单表的查询,要查找"订单日期"为2011年6月份的订单,Where 子句的条件表达式为()
A.订单日期 between "2011-06-01" and "2011-06-30"
B.订单日期 between #2011-06-01# or #2011-06-30#
C.订单日期 between #2011-06-01# and #2011-06-30#
D.订单日期 between 2011-06-01 and 2011-06-30
![](https://static.youtibao.com/asksite/comm/pc/images/content_title_a.png)
A.订单日期 between "2011-06-01" and "2011-06-30"
B.订单日期 between #2011-06-01# or #2011-06-30#
C.订单日期 between #2011-06-01# and #2011-06-30#
D.订单日期 between 2011-06-01 and 2011-06-30
第1题
A.DELETETABLEorderWHERE签订日期<{^2002-1-1}
B.deletetableorderwhile签订日期>{^2002-1-1}
C.DELETEFROMorderWHERE签订日期<{^2002-1-1}
D.deletefromorderwhile签订日期>{^2002-1-1}
第2题
A.SELECT * FROM order WHERE YEAR(签订日期)=2007 ORDER BY 金额 DESC
B.SELECT * FROM order WHILE YEAR(签订日期)=2007 ORDER BY 金额 ASC
C.SELECT * FROM order WHERE YEAR(签订日期)=2007 ORDER BY 金额 ASC
D.SELECT * FROM order WHILE YEAR(签订日期)=2007 ORDER BY 金额 DESC
第3题
A) DELETE TABLE order WHERE 签订日期 <{^2002-1-1}
B) DELETE TABLE order WHILE 签订日期 >{^2002-1-1}
C) DELETE FROM order WHERE 签订日期 <{^2002-1-1}
D) DELETE FROM order WHILE 签订日期 >{^2002-1-1}
第4题
A3NF
B2NF
C1NF
D4NF
第5题
B.使处理时间最短
C.预先确定顺序号
D.优先处理订货量小,相对简单的订单
E.优先处理承诺交货日期最早或约定交货日最近的订单
第9题
A.SELECT * FROM 订单 WHERE SUBSTR(订购单号,4)="1"
B.SELECT * FROM 订单 WHERE SUBSTR(订购单号,4,1)="1"
C.SELECT * FROM 订单 WHERE "1"$订购单号
D.SELECT * FROM 订单 WHERE RIGHT(订购单号,1)="1"