在SQL Server2000中,有商品表(商品号,商品名,单价)和销售表(商品号,

题型:单项选择题

问题:

在SQL Server2000中,有商品表(商品号,商品名,单价)和销售表(商品号,销售时间,销售价格)。现要限制“销售价格”的取值必须在此商品“单价”的0.6~1.5倍范围之内,实现这个约束的正确代码是

A)CHECK(销售价格BETWEEN单价*0.6 AND单价*1.5)
B)CHECK(销售价格BETwEEN商品表.单价*0.6 AND商品表.单价*1.5)
C)CREATE TRIGGER tri Sales ON销售表FOR INSERT,UPDATEAS
IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b)
ON a.商品号=b.商品号
WHERE销售价格NOT BETwEEN单价*0.6 AND单价*1.5)
ROLLBACK
D)CREATE TRIGGER tri Sales ON销售表INSTEAD OF INSERT,UPDATEAS
IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b ON a.商品
号=b.商品号wHERE销售价格NOT BETwEEN单价*0.6 AND单价*1.5)
ROLLBACK

考点:计算机等级考试数据库工程师计算机数据库工程师
题型:单项选择题

Do you        to write with your left hand? If you do, you are one of the millions of “lefties” in the world. Why do some people use left hand more often than others? To understand left-handedness, it is necessary to look at the         . The brain is divided into two hemispheres(半球). The left hemisphere is the center of language and logical thinking. This is where they do their math problems and memorize words. However, the         hemisphere controls how they understand ideas and         they respond(作出反应) to the five senses—sight, hearing,        , taste, and touch. The left hemisphere controls the right side of the body,          the right hemisphere controls the left side. Both sides of the body receive the          information from the brain because they are connected(联系). In right-handed people, the left hemisphere is stronger. In left-handed people, the right hemisphere is         .

Lefties prefer not only the left hand but also the left         . They would rather use the left foot to kick a ball because their whole body is “left-handed”.

From Newtown      Albert Einstein, Wen Jiabao to Obama, Choplin to Zhao Benshan, many    people are left-handed. Are you left-handed even though you are forced to write with your right hand? Don’t worry if you are, you are in good company.

小题1:A. enjoy           B. prefer           C. want

小题2:A. Body                B. hands             C. brain

小题3:A. right              B. left               C. middle

小题4:A. how               B. what             C. why

小题5:A. action               B. thinking         C. smell

小题6:A. although        B. while                C. or

小题7:A. same           B. different           C. difficult

小题8:A. weaker                B. bigger             C. stronger

小题9:A. head           B. ear               C. foot

小题10:A. interesting        B. famous              C. honest

题型:单项选择题

对于“优柔寡断型”的客户,如果客户确已产生购买欲望,销售人员可以采取直接行动,促使客户做出决定。

题型:单项选择题

八会穴共有()。

A.16个

B.15个

C.8个

D.12个

E.10个

题型:单项选择题

一般资料:男性,20岁,待业,因主述情绪低落,压抑、厌学,而来咨询。

案例介绍:求助者性格较内向,由于父母教育严格,因此从小学习很努力,成绩也较好。中考时因感冒发烧发挥失常,只考上一所普通中学,而该学校学习环境不好,学生间打架斗殴不断。高一时因不愿意帮别人写作业,不愿意欺负弱小同学等被其他同学辱骂、殴打,感到自己无能,自我评价较低,后逐渐变得拘谨、胆小,学习成绩也明显下降。从此打不起精神,闷闷不乐,自卑感强,认为别人都讨厌自己不愿与自己一起玩,而他人认为其不合群。求助者曾多次想向父母提出换学校又怕父母添麻烦而没说。父母并没在意其异常,只是要求他努力学习,求助者只好坚持上完高中。虽然埋头苦学但成绩始终不理想。两年前未能考上大学,复读一年后仍然没有考上。之后变得很少与人交流,独来独往,家长邻居都认为其不活泼,不像男子汗。求助者不想继续学习,也不想找工作,半年前曾有过一两次工作机会,因自身原因没有坚持下来。每天无所事事,打不起精神,没有自己想干的事情,对什么都没有兴趣,觉得活着没有一点意义,感到极度痛苦。曾多次到医院就诊,发现没有明显器质性病变,医生考虑其可能有:“神经衰弱”、“神经官能症”,建议看心理门诊,但自己不知道有无心理问题。

该求助者的主要症状是()。

A、意向下降

B、兴趣下降

C、精神低落

D、情绪低落

题型:单项选择题

根据以下业务背景资料,回答相关问题。 广州华兴化工进出口公司2010年7月1日与香港KWANG YANG工业公司签订了购买PE RESIN(聚乙烯树脂)合同,内容如下: PURCHASE CONTRACT    P/C NO. GZHX KYI-10-0010    Date: July 012010                            Signed at: Guangzhou The Buyer: GUANGZHOU HUAXIN CHEMICAL IMP. & EXP. CO., LTD. Address: 151 DONGFENG ROAD,GUANGZHOU,CHINA The Seller: KWANG YANG INDUSTRY CO.,LTD. Address: RW 3A 15/F KWONG BLDG, 72 NARHAN ROAD, KLN, HONG KONG This Purchase Contract is made by and between the Seller and the Buyer whereby the seller grees to sell and the Buyer agrees to buy the under-mentioned goods according to the terms and onditions stipulated below:

1. Package: STANDARD EXPORT PACKAGE 2. Port of Shipment: LONDON 3. Port of Destination: FUTIAN BONDED AREA(福田保税区), SHENZHEN, P.R.CHINA 4. Time of Shipment: IN JULY 5. Shipping Mark: N/M 6. Terms of Payment: BY T/T WITHIN THREE WORKING DAYS AFTER THE SHIPMENT DATE 7. Country of Origin: MADE IN U.S.A THE SELLER THE BUYER KWANG YANG INDUSTRY CO.,LTD. GUANGZHOU HUAXIN CHEMICAL IMP.& EXP.CO.LTD.

经与商务部许可证事务局一处联系,得悉本采购合同项下的PE RESIN(聚乙烯树脂)为“自动进口许可证”货物,据此,外贸跟单员需要申领自动进口许可证吗?什么情况下需要申领?如果货物到达合同目的地后。又被转卖到第三国,是否还需要申领出口许可证?

更多题库