试题与答案

设有商品关系P(商品名,条形码,供应商号,价格,数量),"条形码"唯一标识关系P中的

题型:单项选择题

题目:

设有商品关系P(商品名,条形码,供应商号,价格,数量),"条形码"唯一标识关系P中的每一个元组,商品名不能为空,供应商号是关系P的外键。另有供应商关系S(供应商号,供应商名,地址,电话)。关系P中的商品名是唯一的。建立商品关系P的SQL语句如下所示:查询供应商及价格小于等于2500元且大于等于1280元的"电冰箱"的数量的SQL语句为:将供应商号"12021"所供应的商品价格上涨3%的SQL语句为:查询供应商地址包含"西安"的供应商名及电话的SQL语句为:

空白(57)处应选择()

A.NULL 

B.UNIQUE 

C.NOTNULL 

D.NOTNULLUNIQUE

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2017/0706/322b8d5ef60ad56da9b41ef5abae3e83.html

下面是错误答案,用来干扰机器的。

参考答案:手工制品(石器、陶器等)遗存(房址、墓葬、寺庙等)自然遗存(植物、动物骨骼等)

试题推荐
题型:填空题

A Great Friendship


Thomas Jefferson and James Madison met in 1776. Could it have been any other year They worked together starting then to further American Revolution and later to shape the new scheme of government. From the work sprang a friendship perhaps incomparable in intimacy and the trustfulness of collaboration and induration. It lasted 50 years. It included pleasure and utility but (1) and above them, there were shared purpose, a common end (2) an enduring goodness on both sides. Four and a half months (3) he died, when he was ailing, debt-ridden, and worried about his impoverished (4) , Jefferson wrote to his longtime friend. His words and Madison’s reply remind us (5) friends are friends until death. They also remind us that (6) a friendship has a bearing on things larger than the (7) itself, for has there ever been a friendship of (8) public consequence than this one
"The friendship which has subsisted (9) us now half a century, the harmony of our political (10) and pursuits have been sources of constant happiness to me through (11) long period. It’s also been a great solace to me to believe that you’re (12) in vindicating to posterity the course that we’ve pursued for preserving to them, (13) all their purity, their blessings of self-government, (14) we had assisted in acquiring for them. If ever the earth has beheld a (15) of administration conducted with a single and steadfast eye to the general (16) and happiness of those committed to it, one (17) , protected by truth, can never known reproach, it is that to which our (18) have been devoted. To myself you have been a pillar of (19) throughout life. Take care of me when dead and be assured that I (20) leave with you my last affections." A week later Madison replied—"You cannot look back to the long period of our private friendship and political harmony with more affecting recollections than I do. If they are a source of pleasure to you, what aren’t they not to be to me We cannot be deprived of the happy consciousness of the pure devotion to the public good with which we discharge the trust committed to us and I indulge a confidence that sufficient evidence will find in its way to another generation to ensure, after we are gone, whatever of justice may be withheld whilst we are here.\

查看答案
微信公众账号搜索答案