You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased 

题目

You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means， including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do？（）

  • A、Create a trigger that rolls back changes to the Price column that violate company policy.
  • B、Create a stored procedure that disallows changes to the Price column that violate company policy.
  • C、On the Price column， create a check constraint that requires a specified minimum value.
  • D、On the Price column， create a foreign key constraint to a table that contains valid prices.
相似考题

1.These books, ________ at any bookshop, will give you all the information you need.(A) you can get(B) that you can get(C) what you can get(D) which you can get

2.Lily, nice to see you ! ______ to England ?－－－－ Yes. And I will come back in a week. ( )A、 Have you goneB、 Are you goingC、 Have you beenD、 Did you go

3.Are you still here? You were here half an hour ago. Who( )for?A、were you waitingB、are you waitingC、did you waitD、do you wait

4.Those books, () at any bookshop, will give you all information you need.A、you can getB、that you can getC、what you can getD、which you can get

参考答案和解析
正确答案:A
更多“You are a databa”相关问题

  • 第1题：

    在SQL Server 2000中，要对数据库GoodsDB进行一次差异备份，将其备份到设备Backup 1上(该设备已建立好)，并要求该次备份操作清除Backupl中己有的备份内容。下列能实现该备份要求的语句是

    A．BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITH NOINIT

    B．BACKUP DATABASE GoodsDB TO Backupl WITH DIFFERENTIAL,NOINIT

    C．BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITHINIT

    D．BACKUP DATABA息E GoodsDB TO Backupl WITH DIFFERENTIAL,INIT


    正确答案：D

  • 第2题：

    It’s kind () me the way to the station.

    A、of you to tell

    B、of you telling

    C、for you to tell

    D、for you telling


    参考答案：A

  • 第3题：

    The following hints may help you stay energized, or at least()until you can make the time for rest.

    A、 get you going

    B、 get you go

    C、 get you went


    参考答案：A

  • 第4题：

    听力原文：If you lose your bank notes, the chance for you to get them back is not high.

    (10)

    A．If you lose your bank notes, you will not get them back.

    B．If you lose your bank notes, you will get compensation.

    C．If you lose your bank notes, you can get them back soon.

    D．If you lose your bank notes, most probably, you will not get them back.


    正确答案：D
    解析：单句意思为“如果你丢失了银行支票，你找回它的机会不大。”

  • 第5题：

    共用题干
    Knowing Your Real Personality from Sleeping Positions Everyone has got two personalities—the one that is shown to the world and the other that is secret and real. You don't show your secret personality when you're awake because you, can control yourself,but when you're asleep,your sleeping position shows the real you .In a normal night,of course,you often change your sleeping positions .The important position that best shows your se- cret personality is the one that you go to sleep. If you go to sleep on your back,you're a very open person .You normally trust people and you are easily influenced by new ideas.You don't like to make people unhappy,so you never ex- press your real feelings.You're quite shy and you aren't very confident. If you sleep on your stomach,you are a person who likes to keep secrets.You worry a lot and you're always easily becoming sad.You never want to change your ideas,but you are satisfied with your life the way it is .You usually live for today not for tomorrow. If you sleep on curled up,you are probably a very nervous person.You have a low opinion of yourself and often protect yourself from being hurt,so you are very defensive .You're shy and you don't usually like meeting people.You like to be on your own. If you sleep on your side,you have usually got a well-balanced personality.You know your strengths and weaknesses.You're usually careful. You have a confident personality.You sometimes feel worried,but you don't often get unhappy .You always say what you think,even if it makes people angry.

    When does the sleeping position best show your secret personality?
    A: In the daytime.
    B: At the beginning of sleep.
    C: At night.
    D: During the deep sleep.

    答案：B
    解析：
    整篇文章介绍的是人物的性格特征，有外在的和内在的，这说明和科学有关。


    根据文章第一段中“The important position that best shows your secret personality is the one that you go to sleep.”可知应该是开始睡的时候。


    由文章第三段中的“If you sleep on your stomach, you are a person who likes to keep secrets.”可知。


    从文章第四段中“You have a low opinion of yourself and often protect yourself from be-ing hurt.”可知，保护自己不受到伤害，那么defensive意为“有戒心的”。


    由文章中的第二段到第五段可知。

  • 第6题：

    共用题干
    Knowing Your Real Personality from Sleeping Positions Everyone has got two personalities—the one that is shown to the world and the other that is secret and real. You don't show your secret personality when you're awake because you, can control yourself,but when you're asleep,your sleeping position shows the real you .In a normal night,of course,you often change your sleeping positions .The important position that best shows your se- cret personality is the one that you go to sleep. If you go to sleep on your back,you're a very open person .You normally trust people and you are easily influenced by new ideas.You don't like to make people unhappy,so you never ex- press your real feelings.You're quite shy and you aren't very confident. If you sleep on your stomach,you are a person who likes to keep secrets.You worry a lot and you're always easily becoming sad.You never want to change your ideas,but you are satisfied with your life the way it is .You usually live for today not for tomorrow. If you sleep on curled up,you are probably a very nervous person.You have a low opinion of yourself and often protect yourself from being hurt,so you are very defensive .You're shy and you don't usually like meeting people.You like to be on your own. If you sleep on your side,you have usually got a well-balanced personality.You know your strengths and weaknesses.You're usually careful. You have a confident personality.You sometimes feel worried,but you don't often get unhappy .You always say what you think,even if it makes people angry.

    You may find the passage in_______.
    A: a science magazine
    B: a guide book
    C: a sports newspaper
    D: a story book

    答案：A
    解析：
    整篇文章介绍的是人物的性格特征，有外在的和内在的，这说明和科学有关。


    根据文章第一段中“The important position that best shows your secret personality is the one that you go to sleep.”可知应该是开始睡的时候。


    由文章第三段中的“If you sleep on your stomach, you are a person who likes to keep secrets.”可知。


    从文章第四段中“You have a low opinion of yourself and often protect yourself from be-ing hurt.”可知，保护自己不受到伤害，那么defensive意为“有戒心的”。


    由文章中的第二段到第五段可知。

  • 第7题：

    How do you do? Glad to meet you.（）

    AFine. How are you?

    BHow do you do? Glad to meet you, too.

    CHow are you? Thank you! 

    DNice. How are you?


    B
    略

  • 第8题：

    Nice to see you again, Mr. Smith. How are you?（）

    • A、I miss you.
    • B、Fine. Thank you. And you? 
    • C、Are you OK? 
    • D、This way, please.

    正确答案:B

  • 第9题：

    在航向上吗？（）

    • A、Are you on the course?
    • B、Are you on the line ?
    • C、Are you on the wheel?
    • D、Are you on the route?

    正确答案:A

  • 第10题：

    单选题
    －Nice to meet you. －（）
    A

    Fine, thank you. 

    B

    How are you? 

    C

    Nice to meet you, too. 

    D

    Thank you


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    If you were offered a trip to the moon, ______ it?
    A

    did you accept

    B

    are you going to accept

    C

    will you accept

    D

    would you accept


    正确答案： C
    解析：
    这道题的考点是与现在事实相反的虚拟语气。这样的句子中从句要用过去时，主句用would／should／could+动词原形。

  • 第12题：

    单选题
    Nice to see you again, Mr. Smith. How are you?（）
    A

    I miss you.

    B

    Fine. Thank you. And you? 

    C

    Are you OK? 

    D

    This way, please.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    7．—Happy birthday to you !

    —__________．

    A． You are good

    B． Great

    C． You are right

    D． Thank you


    正确答案：D
    7．D【解析】用“Thank you．”回答别人对自己的祝福．

  • 第14题：

    When you are young you think you are ( ): you feel you can achieve anything.

    A. vigorous

    B. interesting

    C. indispensable

    D. invincible


    参考答案：D

  • 第15题：

    ______ that dress when I first saw you at the station?

    A、Were you wearing

    B、Have you worn

    C、Did you wear

    D、Do you wear


    正确答案:A

  • 第16题：

    You have a computer that runs Windows Vista.You connect to your company’s network by using a virtual private network (VPN) connection. You notice that when you establish the VPN connection, you are unable to access Internet Web sites. When you disconnect the VPN connection, you can access Internet Web sites.You need to access Internet Web sites while you are connected to the VPN connection.What should you do?（）

    A.A

    B.B

    C.C

    D.D


    参考答案：D

  • 第17题：

    共用题干
    Knowing Your Real Personality from Sleeping Positions Everyone has got two personalities—the one that is shown to the world and the other that is secret and real. You don't show your secret personality when you're awake because you, can control yourself,but when you're asleep,your sleeping position shows the real you .In a normal night,of course,you often change your sleeping positions .The important position that best shows your se- cret personality is the one that you go to sleep. If you go to sleep on your back,you're a very open person .You normally trust people and you are easily influenced by new ideas.You don't like to make people unhappy,so you never ex- press your real feelings.You're quite shy and you aren't very confident. If you sleep on your stomach,you are a person who likes to keep secrets.You worry a lot and you're always easily becoming sad.You never want to change your ideas,but you are satisfied with your life the way it is .You usually live for today not for tomorrow. If you sleep on curled up,you are probably a very nervous person.You have a low opinion of yourself and often protect yourself from being hurt,so you are very defensive .You're shy and you don't usually like meeting people.You like to be on your own. If you sleep on your side,you have usually got a well-balanced personality.You know your strengths and weaknesses.You're usually careful. You have a confident personality.You sometimes feel worried,but you don't often get unhappy .You always say what you think,even if it makes people angry.

    What does the passage tell us?
    A: Sleeping on your side is the best way of sleeping.
    B: Changing positions will cause sleeping problems.
    C:.Sleeping positions show people's secret personalities.
    D:.Enough sleep makes people look better and healthier.

    答案：C
    解析：
    整篇文章介绍的是人物的性格特征，有外在的和内在的，这说明和科学有关。


    根据文章第一段中“The important position that best shows your secret personality is the one that you go to sleep.”可知应该是开始睡的时候。


    由文章第三段中的“If you sleep on your stomach, you are a person who likes to keep secrets.”可知。


    从文章第四段中“You have a low opinion of yourself and often protect yourself from be-ing hurt.”可知，保护自己不受到伤害，那么defensive意为“有戒心的”。


    由文章中的第二段到第五段可知。

  • 第18题：

    Wish you a happy holiday.（）

    AI hope so.

    BYou are so kind.

    CThank you, do you?

    DThank you, the same to you.


    D
    略

  • 第19题：

    －Nice to meet you. －（）

    AFine, thank you. 

    BHow are you? 

    CNice to meet you, too. 

    DThank you


    C
    略

  • 第20题：

    下面代码执行后，正确的输出结果是（）。

    • A、You are fired!     You are hired!
    • B、You are fired!     You are fired!
    • C、You are hired!     You are hired!
    • D、You are hired!     Youarefired!

    正确答案:A

  • 第21题：

    单选题
    How do you do? Glad to meet you.（）
    A

    Fine. How are you?

    B

    How do you do? Glad to meet you, too.

    C

    How are you? Thank you! 

    D

    Nice. How are you?


    正确答案： D
    解析： 暂无解析

  • 第22题：

    问答题
    【参考范例七】PART 2Describe a person you live with or used to live with. You should say:  when you lived together  what is special about this person  whether you live together now  and explain why you choose this person to talk about.You will have to talk about the topic for one or two minutes.You have one minute to think about what you’re going to say.You can make some notes to help you if you wish.

    正确答案： I’d like to talk about my grandfather who is a very caring and kind person. We have lived together for many years. My grandfather was a middle school teacher in his hometown. He managed to send all of his to school though his salary was very low. He thought education is very important through a person’s life. I was brought up at my grandfather’s home. He taught me a lot of knowledge and he was very kind and nice to me. I never forget the efforts he made to help me read. He was a patient person and taught me as much as he could. He spent much time helping me and teaching me the right way to read. At last, the way worked. I learned to read quickly. When I was to be in the middle school, I left grandfather’s home and I missed him very much and the lessons I learnt from my grandfather always kept in mind.
    解析：
    描述一个和你住在一起或者曾经和你住在一起的人。考生应说明这个人跟自己的关系，他／她是一个什么样的人；自己什么时候跟他／她住在一起，他／她对自己的影响等；并说明自己对他／她的评价。

  • 第23题：

    单选题
    “I love you, and because I love you, I would sooner _____ me for telling you the truth than adore me for telling you lies.” Pietro Aretino quotes.
    A

    made you dislike

    B

    to let you admire

    C

    have you hate

    D

    you distaste for


    正确答案： D
    解析：
    句意：我爱你，正是因为我爱你，我宁愿告诉你真话让你去恨我，也不愿告诉你假话让你去爱我。would sooner do sth. than do sth.宁愿做……而不去做……。 have sb.do让某人做某事。would sooner后面接动词原形。所以C选项正确。

  • 第24题：

    单选题
    _____ ten minutes earlier, you wouldn't have missed the train. But you were late.
    A

    Had you come

    B

    Did you come

    C

    Have you come

    D

    Should you come


    正确答案： D
    解析：

相关内容