itgle.com

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Custome

题目

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）

  • A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
  • B、Create a CHECK constraint.
  • C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
  • D、Create a DML AFTER trigger that writes the failed records to a file or table.
相似考题

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

参考答案和解析
正确答案:C
更多“You are planning&ensp”相关问题

  • 第1题：

    7．—Happy birthday to you !

    —__________．

    A． You are good

    B． Great

    C． You are right

    D． Thank you


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

  • 第2题：

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

    A. vigorous

    B. interesting

    C. indispensable

    D. invincible


    参考答案：D

  • 第3题：

    ______ 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

  • 第4题：

    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

  • 第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.

    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意为“有戒心的”。


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

  • 第6题：

    Wish you a happy holiday.（）

    AI hope so.

    BYou are so kind.

    CThank you, do you?

    DThank you, the same to you.


    D
    略

  • 第7题：

    －Nice to meet you. －（）

    AFine, thank you. 

    BHow are you? 

    CNice to meet you, too. 

    DThank you


    C
    略

  • 第8题：

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

    • 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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    问答题
    【参考范例七】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.
    解析：
    描述一个和你住在一起或者曾经和你住在一起的人。考生应说明这个人跟自己的关系，他／她是一个什么样的人；自己什么时候跟他／她住在一起，他／她对自己的影响等；并说明自己对他／她的评价。

  • 第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题：

    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

  • 第14题：

    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

  • 第15题：

    听力原文：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
    解析：单句意思为“如果你丢失了银行支票，你找回它的机会不大。”

  • 第16题：

    共用题干
    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意为“有戒心的”。


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

  • 第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.

    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意为“有戒心的”。


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

  • 第18题：

    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
    略

  • 第19题：

    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

  • 第20题：

    在航向上吗？（）

    • 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

  • 第21题：

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

    Fine, thank you. 

    B

    How are you? 

    C

    Nice to meet you, too. 

    D

    Thank you


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

  • 第22题：

    问答题
    【参考范例二】PART 2Describe a colleague that you like to work with. You should say:  what this person does  what sort of work you do with this person  how long you have known each other  and explain why you like to work with this person.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 the guy I met during my internship at a local station. We were both working at the evening news section. His name was Jack and he was responsible for news editing while I was the assistant of the chief editor. On the first day of work, I simply spin around with lots of paper materials and tapes in my hands and couldn’t find my way. Jack leaded me to the office and helped me work out those papers. He was very competent and responsible. Besides, he was outgoing and warm-hearted with a big smile on his face. He was really a nice guy to work with. Before long, he became very popular among all the colleagues. Everybody enjoyed talking to him and being around him. I liked working with him too. He would strive to solve others’ trouble. I’ve known him for 4 years and I wish we could be colleagues again someday.
    解析：
    考生应说明这个人是谁或他／她的名字，在什么时候遇到的，他／她做什么工作(secretary, typist, tutor, door-to-door  salesman)；他／她的性格特点(friendly, cute，shy, hospital，warm-hearted)；以及自己为什么喜欢跟他／她一起工作。

  • 第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
    解析：

相关内容