多选题What are two reasons to create synonyms? ()AYou have too many tables.BYour tables are too long.CYour tables have difficult names.DYou want to work on your own tables.EYou want to use another schema's tables.FYou have too many columns in your tables.

题目
多选题
What are two reasons to create synonyms? ()
A

You have too many tables.

B

Your tables are too long.

C

Your tables have difficult names.

D

You want to work on your own tables.

E

You want to use another schema's tables.

F

You have too many columns in your tables.


相似考题

4.AThe undersea world is very beautiful. Now more and more people want to dive in the water to find the secrets there. Scuba diving is a new sport today. It can take you into a wonder-ful undersea world.You will find many strange animals in the sea. Some are as large as a school bus. Many sea animals give out light in the dark and some have sharp teeth.During the day, there is enough light. Here, under the sea, everything is blue and green.When fish swim nearby, you can catch them with your hands. When you have bottles of air on your back, you can stay in deep water for a long time. However, you can-t dive too deep. And you must be very careful when you dive in deep water.The deep sea is not an easy place to live in. It-s cold, and it,s dark, too. The deeper it is, the less sunlight there is. At about 3,000 feet, there is no light at all. It is very dark in the sea. Many fishes have no eyes. Some have big eyes. A few have eyes on one side. Besides the cold and the darkness, deep-sea animals face a third danger-other animals.Animals eat! They must find food to eat. Many animals eat plants. However, some am-mals eat meat. This means these sea animals have two big jobs. They need to find animals as food, and they have to try not to become other animals' meal.( )21. Why do people want to dive in the sea? Because ________ .A.they want to catch fishB. they want to find the secrets of the undersea worldC. the sea is deepD, there are all kinds of plants in the sea

更多“多选题What are two reasons to create synonyms? ()AYou have too many tables.BYour tables are too long.CYour tables have difficult names.DYou want to work on your own tables.EYou want to use another schema's tables.FYou have too many columns in your tables.”相关问题
  • 第1题:

    What is necessary for your query on an existing view to execute successfully? ()

    A. The underlying tables must have data.

    B. You need SELECT privileges on the view.

    C. The underlying tables must be in the same schema.

    D. You need SELECT privileges only on the underlying tables.


    参考答案:B

  • 第2题:

    You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.

    You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.

    You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.

    What should you do?

    A.Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.

    B.Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.

    C.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.

    D.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.


    正确答案:D
    解析:Explanation:Asthecolumnsthatwewantinthetextfileareondifferenttablesinthedatabase,wewouldhavetocombinethecolumnintoatableorview.Becausewewillnotneedtoreproducethefile,wecanwecancombinethecolumnfromthevarioustablesintoaglobaltemporarytablebyusingtheSELECTINTOstatement.Thenweusethebcputilitytoexportthedatafromtheglobaltemporaryfiletoatextfile.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.Ifglobaltemporarytablesarenotdroppedexplicitlybeforetheconnectionthatcreatedthemdisconnects,theyaredroppedassoonasallothertasksstopreferencingthem.Nonewtaskscanreferenceaglobaltemporarytableaftertheconnectionthatcreateditdisconnects.ThebcputilitycopiesdatabetweenaninstanceofSQLServer2000andadatafileinauser-specifiedformat.ItcanbeusedtotransferdatafromaSQLServertabletoadatafileforuseinotherprograms.Furthermore,datacanalsobetransferredoutbyspecifyingaSELECTstatement.Thebcputilitycanuseglobaltemporarytables,butnotlocaltemporarytables.IncorrectAnswers:A:CreatingaglobaltemporarytablebyusingtheSELECTstatementandusingthebcputilitytoexportdatafromthattablewouldrequirelessadministrativeeffortthanusingbcptoexporttherequiredcolumnsfromeachtableintoaseparatetextfileandthenmergingthosetextfilesintoasingletextfile.B:Becausewewouldnotneedtore-createthedatafileagain,itwouldbeeasiertousetheSELECTstatementtocreateaglobaltemporarytableasthesetablesaredroppedautomaticallywhennothingreferencethem.C:Thebcputilitycannotuselocaltemporarytables.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.

  • 第3题:

    It is often difficult to get correct information on campus crime because some colleges 。

    A. receive too many visitors

    B. mirror the rest of the nation

    C. hide the truth of campus crime

    D. have too many watchdog groups


    正确答案:C
    文章第四段提到But getting accurate information isn’t easy. Colleges must report crime statistics by law, but some hold back for fear of bad publicity, leaving the honest ones looking dangerous. 可以看出正确选项。

  • 第4题:

    Many pure metals have little use because they are too soft,rust too easily,or have some other drawback.

    A:property
    B:additive
    C:disadvantage
    D:disparity

    答案:C
    解析:
    本句意思:很多纯金属用处很小,因为它们要么太软,太容易生锈,要么有某种其他缺点。drawback缺点。disadvantage缺点;property属性,性质;additive添加剂;disparity不同,不 等,不一致。

  • 第5题:

    What a beautiful dress you have on today!()

    • A、It is suitable for me.
    • B、No, it isn't.
    • C、You want to have  one, too?
    • D、Thank you

    正确答案:D

  • 第6题:

    What is necessary for your query on an existing view to execute successfully? ()

    • A、The underlying tables must have data.
    • B、You need SELECT privileges on the view.
    • C、The underlying tables must be in the same schema.
    • D、You need SELECT privileges only on the underlying tables.

    正确答案:B

  • 第7题:

    In which two cases would you use an outer join? ()

    • A、The tables being joined have NOT NULL columns.
    • B、The tables being joined have only matched data.
    • C、The columns being joined have NULL values.
    • D、The tables being joined have only unmatched data.
    • E、The tables being joined have both matched and unmatched data.
    • F、Only when the tables have a primary key/foreign key relationship.

    正确答案:C,E

  • 第8题:

    单选题
    A: ______, if I may.  B: I’d rather you didn’t, because there is too much work to do in the office.
    A

    I’d like to have a good time    

    B

    I’d like to have a day off

    C

    I want to have a try  

    D

    I want to see a doctor


    正确答案: D
    解析:
    根据上下文,后文说你最好不要这么做,因为工作很忙,而与此相符合的前文就是请假。

  • 第9题:

    多选题
    In which three cases would you use the USING clause?()
    A

    You want to create a nonequijoin.

    B

    The tables to be joined have multiple NULL columns.

    C

    The tables to be joined have columns of the same name and different data types.

    D

    The tables to be joined have columns with the same name and compatible data types.

    E

    You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.


    正确答案: C,B
    解析: 暂无解析

  • 第10题:

    单选题
    Have a nice holiday!()
    A

    You have it too.

    B

    You do too.

    C

    The same as you

    D

    The same to you.


    正确答案: B
    解析: 暂无解析

  • 第11题:

    多选题
    In which two cases would you use an outer join? ()
    A

    The tables being joined have NOT NULL columns.

    B

    The tables being joined have only matched data.

    C

    The columns being joined have NULL values.

    D

    The tables being joined have only unmatched data.

    E

    The tables being joined have both matched and unmatched data.

    F

    Only when the tables have a primary key-foreign key relationship.


    正确答案: D,C
    解析: 暂无解析

  • 第12题:

    单选题
    What a beautiful dress you have on today!()
    A

    It is suitable for me.

    B

    No, it isn't.

    C

    You want to have  one, too?

    D

    Thank you


    正确答案: B
    解析: 暂无解析

  • 第13题:

    The author believes the real cause for the increase of divorces today is that______.

    A)people have too many sources of entertainment

    B) people have less internal restraints

    C) people no longer enjoy family life as they did before

    D)people do not want to be confined by marital ties


    正确答案:B
    答案:B
    [试题分析]细节判断题。
    [详细解答]在文章第一、二段,作者探讨了离婚增多的原因。他认为,社会的纵容、放任(permissiveness)使人们产生了不切实际的幻想,人们不愿做出婚姻需要夫妻双方所做出的牺牲,只想放纵自己。婚姻需要夫妻双方做出牺牲,需要他们在某些方面的自我约束(self—discipline),而不能靠冲动行事。可见,作者认为离婚的主要原因是人们缺乏内在的自制(internal restraints)。

  • 第14题:

    In which three cases would you use the USING clause?()

    A.You want to create a nonequijoin.

    B.The tables to be joined have multiple NULL columns.

    C.The tables to be joined have columns of the same name and different data types.

    D.The tables to be joined have columns with the same name and compatible data types.

    E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.


    参考答案:C, D, E

  • 第15题:

    --Have your students ever seen the silent film?

    --No, they are too young ______ the old film.

    A. to seeing

    B. have seen

    C.to have seen

    D. to have


    正确答案:C

    答案为C。“你的学生们看过无声电影吗?”“没有,他们太年轻了,没有看过老电影。”不定式的完成式表示不定式的动作发生在谓语动词之前。只有C形式正确。

  • 第16题:

    Have a nice holiday!()

    AYou have it too.

    BYou do too.

    CThe same as you

    DThe same to you.


    D

  • 第17题:

    They have done()work these days.

    • A、too much
    • B、much too
    • C、too many
    • D、many too

    正确答案:A

  • 第18题:

    What are two reasons to create synonyms? ()

    • A、You have too many tables.
    • B、Your tables are too long.
    • C、Your tables have difficult names.
    • D、You want to work on your own tables.
    • E、You want to use another schema's tables.
    • F、You have too many columns in your tables.

    正确答案:C,E

  • 第19题:

    Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? ()

    • A、An error is generated.
    • B、You will have two identical tables in the HR schema with different names.
    • C、You create a table called employees in the HR schema based on you EMP table.
    • D、You create an alternative name for the employees table in the HR schema in your own schema.

    正确答案:D

  • 第20题:

    单选题
    According to the passage, people have difficulty getting to sleep because ______.
    A

    they work more than sixty hours a week

    B

    they have too many enemies

    C

    they do not sleep happily

    D

    they are not tired enough


    正确答案: C
    解析:
    文章首段指出据爱丁堡大学的Dr. Ian Oswald称世界上十分之一的人都入睡困难,原因很简单,大多数人睡不着觉是因为自身问题:他们睡得太早了。也就是说身体还不累就睡觉了,故D项符合题意。

  • 第21题:

    填空题
    If your neighbors are too noisy, then you have a good reason to make your (complain) ____.

    正确答案: complaint
    解析:
    本题考查词性转换。句意:如果你的邻近太吵,那么你有充分的理由抱怨了。空格前是形容词性物主代词your,后面需要填入名词,这里使用complain的名词形式complaint,意为“抱怨,诉苦”。

  • 第22题:

    多选题
    What are two reasons to create synonyms? ()
    A

    You have too many tables.

    B

    Your tables are too long.

    C

    Your tables have difficult names.

    D

    You want to work on your own tables.

    E

    You want to use another schema's tables.

    F

    You have too many columns in your tables.


    正确答案: D,A
    解析: 暂无解析

  • 第23题:

    单选题
    What is necessary for your query on an existing view to execute successfully?()
    A

    The underlying tables must have data.

    B

    You need SELECT privileges on the view.

    C

    The underlying tables must be in the same schema.

    D

    You need SELECT privileges only on the underlying tables.


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

  • 第24题:

    单选题
    Tom: You need a break. Why don’t we go to a movie tonight?  Tony: ______  Tom: You work too hard. A break would do you good.
    A

    Why did you ask?

    B

    Have you finished your dinner yet?

    C

    I have seen French movies many times.

    D

    I’d love to, but I have a lot of work to do.


    正确答案: D
    解析:
    Tom约Tony去看电影,由Tom最后的回答可知,Tony是拒绝去看电影的