问题 单项选择题

关于SQL的超联接查询,说法错误的是

A.在SQL中可以进行内部联接、左联接、右联接和全联接

B.SQL的超联接运算符“*=”代表左联接,“=*”代表右联接

C.Visual FoxPro同样支持超联接运算符“*=”和“=*”

D.利用全联接,即使两个表中的记录不满足联接条件,也会在目标表或查询结果中出现,只是不满足条件的记录对应部分为NULL

答案

参考答案:C

解析:[命题目的] 本题考查了考生对SQL查询功能的掌握情况。
[解题要点] SQL的超联接运算符中“*=”代表左联接,“=*”代表右联接。但在Visual FoxPro中,不支持超联接运算符“*=”和“=*”,它有专门的联接运算语法格式,分别用LEFT JOIN 和 RIGHT JOIN表示。
[错解分析] Visual FoxPro支持左联接和右联接运算查询,但不能使用“=*”和“*=”运算符查询,只能用Visual FoxPro中专用的命令短语才可以。
[考点链接] SQL超联接查询。

单项选择题 共用题干题
完形填空
Don’t Wait Until Flowers Fade
Each spring brings a new blossom of wildflowers in the ditches (路沟) along the highway I travel daily to work.
There is one       blue flower that has always       my eye. I’ve noticed that it blooms only in the morning hours, and the afternoon sun is too warm       it. Every day for approximately two weeks, I see those beautiful      .
This spring, I started a wildflower garden in our yard. I can look out of the       window while doing the dishes and see the flowers. I’ve often thought that those lovely blue flowers from the ditch would look       in that bed alongside       wildflowers.
Everyday I drove       the flowers thinking, “I’ll stop on my way home and dig them.” “Gee, I don’t want to get my good clothes       ...” Whatever the reason, I never stopped to dig them. My husband       gave me a folding shovel(铁锹) one year to be used for that      purpose.
One day on my way home from work, I was       to see that the highway department had moved the ditches and the pretty blue flowers were gone. I thought to myself, “Way to go, you       too long. You       it when you first saw them blooming this spring.”
A week ago we were shocked and saddened to learn that my oldest sister-in-law has a terminal brain tumor(脑瘤晚期). She is 20 years older than my husband and      , because of age and distance, we haven’t been as      as we all would have liked.
I couldn’t help but see the       between the pretty blue flowers and the     between my husband’s sister and us. I do believe that God has given us some time left to plant some valuable       that will bloom every year for us.
And yes, if I see the blue flowers again, you can bet I'll stop and       them to my wildflower garden
小题1:
A.sweetB.interestingC.differentD.particular
小题2:
A.fascinatedB.struckC.caughtD.charm
小题3:
A.forB.toC.withD.on
小题4:
A.plantsB.flowersC.onesD.wilds
小题5:
A.openB.main hallC.frontD.kitchen
小题6:
A.greatB.wellC.horribleD.ugly
小题7:
A.manyB.variousC.otherD.colorful
小题8:
A.passedB.pastC.passD.pasted
小题9:
A.damagedB.readyC.dirtyD.smelly
小题10:
A.everB.onceC.neverD.even
小题11:
A.expressedB.temporaryC.unfinishedD.permanent
小题12:
A.annoyingB.saddenedC.interestedD.helpless
小题13:
A.wastedB.ignoredC.thoughtD.waited
小题14:
A.would have doneB.need have doneC.should have doneD.muse have done
小题15:
A.unconsciouslyB.fortunatelyC.unfortunatelyD.consciously
小题16:
A.closeB.closelyC.closedD.near
小题17:
A.connectionB.differenceC.meaningD.significance
小题18:
A.friendshipB.relationshipC.supportD.relative
小题19:
A.treesB.memoriesC.speciesD.roses
小题20:
A.digB.rescueC.transmitD.transplant