第16题: [多项选择]【说明】 有如下关系数据库： S(SNO，SN，STATUS，CITY) P(PNO，PN，COLORS，WEIGHT) J(JNO，JN，CITY) SPJ(SNO，PNO，JNO，QTY) 其中，S为供应单位，P为零件，J为工程项目，SPJ为工程订购零件的订单，其语义为：某供应单位供应某种零件给某个工程，请用SQL完成下列操作。 【问题3】 求至少有一个和工程不在同一城市的供应商提供零件的工程代号。 参考答案:SELECT DISTINCT SPJ.JNO FROM ANDJ.JNO=SPJ.JNO AND S,CITY＜＞J.CITY 答案解析:[解析]这道题比较简单直接，只是考查考生的基本SQL语句的掌握和使用。
第17题: [单项选择]The hours ______ the children spend in their one-way relationship with television people undoubtedly affect their relationships with real-life people. A. when B. on which C. that D. in which 参考答案:C 答案解析:定语从句中的谓语动词spend是及物动词，因此此处需要一个既能引导定语从句，又可以作spend宾语的关系代词，可见[C]是惟一正确答案。更多例句：There are many inconvenienc
第29题: [简答题]A. We would like to be paid for the stock. B. We would like to adapt ourselves to the present situation. C. Installment is acceptable for the transactions at present. D. We would like to store our money here. 参考答案: 答案解析:[解析] We would like to adopt payment by installments for our present transaction.
