You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment

题目

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

  • A、The Automatic Memory Manager (AMM)
  • B、The SQL Tuning Advisor
  • C、The Segment Advisor
  • D、The SQL Access Advisor SQL
相似考题

1.Wild dogs are dangerous predators because they ______.A. are very fierceB. hunt in large packsC. are very intelligentD. have unusually large litters

2.have you ever seen ____ carpet?A. such a beautiful large green ChineseB. such a green beautiful large ChineseC. such a Chinese beautiful large greenD. such a beautiful green large Chinese

3.You look very tired. You ____ too hard these days.A. could have workedB. ought to have workedC. should have workedD. must have worked

4.You look very tire You must ( ) to bed very late last night.A、have goneB、have been goneC、be goneD、be going

参考答案和解析
正确答案:D
更多“You have a very large table that”相关问题

  • 第1题：

    You executed the following commands in a database session:What could have caused the recycle bin to clean up?()

    A. There is demand for space from the new table从

    B. The undo tablespace does not have sufficient free space

    C. The new table name is the same as the table name in the recycle bin

    D. The temporary tablespace that is assigned to you does not have sufficient free space


    参考答案：A

  • 第2题：

    In the US,people prefer waiting for a table to sitting with people they don't know．This means a hostess may not seat a small group until a small table is available,even if a large one is．If you are sitting at a table with people you don't know,it is impolite to light up a cigarette without first asking if it will disturb them.
    At American restaurants and coffee shops you are usually served tap water before you order．You may find the bread and butter is free,and if you order coffee,you may get a free refill.
    Most cities and towns have no roles about opening and closing times for stores or restaurants,though they usually do make rules for bars．Especially in large cities,stores may be open 24 hours a day．
    Servings in restaurants are often large,too large for many people．If you can't finish your meal but would like to enjoy the food later,ask your waitress or waiter for a"doggie bag"．It may have a picture of a dog on it,but everybody knows you are taking food for yourself.
    Supper and dinner are both words for the evening meal．Some people have"Sunday dinner"．This is an especially big noon meal.
    Tips are not usually added to the check．They are not included in the price of the meal,either．A tip of about 15%is expected and you should leave it on the table when you leave．In some restaurants,a check is brought on a plate and you put your money there．Then the waiter or waitress brings you your change.

    Sunday dinner is~

    A.a dinner in the evening
    B.a big noon meal
    C.a big meal on Sunday
    D.a supper on Sunday

    答案：B
    解析：
    参见句子：Some people have“Sunday dinner”．This is an especially big noon meal．

  • 第3题：

    In the US,people prefer waiting for a table to sitting with people they don't know．This means a hostess may not seat a small group until a small table is available,even if a large one is．If you are sitting at a table with people you don't know,it is impolite to light up a cigarette without first asking if it will disturb them.
    At American restaurants and coffee shops you are usually served tap water before you order．You may find the bread and butter is free,and if you order coffee,you may get a free refill.
    Most cities and towns have no roles about opening and closing times for stores or restaurants,though they usually do make rules for bars．Especially in large cities,stores may be open 24 hours a day．
    Servings in restaurants are often large,too large for many people．If you can't finish your meal but would like to enjoy the food later,ask your waitress or waiter for a"doggie bag"．It may have a picture of a dog on it,but everybody knows you are taking food for yourself.
    Supper and dinner are both words for the evening meal．Some people have"Sunday dinner"．This is an especially big noon meal.
    Tips are not usually added to the check．They are not included in the price of the meal,either．A tip of about 15%is expected and you should leave it on the table when you leave．In some restaurants,a check is brought on a plate and you put your money there．Then the waiter or waitress brings you your change.

    Which statement is not mentioned in the passage?

    A.Tips are not usually included in the total chec
    B.A 15 percent tip in large cities indicates satisfactory servic
    C.People tip waiters and waitresse
    D.People always put tips on the tabl

    答案：B
    解析：
    参见最后一段。

  • 第4题：

    Can I get you a drink?（）But I have already got one

    AThat's very nice of you

    BNo, you don't have to

    CYes, please 

    DWith pleasure


    A
    略

  • 第5题：

    While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） 

    • A、A primary key must have been created.
    • B、A mapping table must have been created.
    • C、An overflow tablespace must have been specified.
    • D、The PCTTHRESHOLD option must have been specified.

    正确答案:B

  • 第6题：

    You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）

    • A、— quick
    • B、— skip-buffer
    • C、— single-transaction
    • D、— tab

    正确答案:A

  • 第7题：

    单选题
    You have a very large table that your users access frequently.  Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）
    A

     The Automatic Memory Manager （AMM）

    B

     The SQL Tuning Advisor

    C

     The Segment Advisor

    D

     The SQL Access Advisor


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

  • 第8题：

    单选题
    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
    A

    The Automatic Memory Manager (AMM)

    B

    The SQL Tuning Advisor

    C

    The Segment Advisor

    D

    The SQL Access Advisor


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

  • 第9题：

    单选题
    You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）
    A

    — quick

    B

    — skip-buffer

    C

    — single-transaction

    D

    — tab


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

  • 第10题：

    单选题
    You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）
    A

    Upgrade the hardware/memory to accommodate the data.

    B

    Load the data into your database by using the PARALLEL clause.

    C

    Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.

    D

    Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.


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

  • 第11题：

    单选题
    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

    export and import the mapping table

    B

    drop and re-create the mapping table

    C

    truncate the mapping table and reinsert the values

    D

    use the ALTER TABLE···REBUILD command to defragment the mapping table


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

  • 第12题：

    单选题
    Ray: Have you met the new boss yet?　David: No, tell me—what’s he like?　Ray: Well, I met him this morning and my first impression was very positive. _______, and I hear he’s got a great sense of humor.　David: That’s great!
    A

    He came across as very pleasant    

    B

    He has a large office

    C

    He seems very unfriendly  

    D

    He’s not very sharp


    正确答案： A
    解析： come across走过来。横线前一句为“我对他的第一印象非常良好”，因此紧接着谈“他非常愉悦地走过来”符合会话语境。

  • 第13题：

    you have some very large shoes to fill?中文是什么意思?

    如题


    你有一些非常大的鞋子去填满

    To move into someone's else place is to step into their shoes. If they've done an excellent job, it will be said they have big shoes for you to fill. It means you will have to do an excellent job to be as good as the person before you.
    （搜来的啊，不是我写的）

    《The Devil Wears Prada》有这一台词
    Emily:You have some very large shoes to fill.I hope you know that.

    所以susannrr的翻译挺好的啊
    你得好好努力才能赶上你的前任

  • 第14题：

    In the US,people prefer waiting for a table to sitting with people they don't know．This means a hostess may not seat a small group until a small table is available,even if a large one is．If you are sitting at a table with people you don't know,it is impolite to light up a cigarette without first asking if it will disturb them.
    At American restaurants and coffee shops you are usually served tap water before you order．You may find the bread and butter is free,and if you order coffee,you may get a free refill.
    Most cities and towns have no roles about opening and closing times for stores or restaurants,though they usually do make rules for bars．Especially in large cities,stores may be open 24 hours a day．
    Servings in restaurants are often large,too large for many people．If you can't finish your meal but would like to enjoy the food later,ask your waitress or waiter for a"doggie bag"．It may have a picture of a dog on it,but everybody knows you are taking food for yourself.
    Supper and dinner are both words for the evening meal．Some people have"Sunday dinner"．This is an especially big noon meal.
    Tips are not usually added to the check．They are not included in the price of the meal,either．A tip of about 15%is expected and you should leave it on the table when you leave．In some restaurants,a check is brought on a plate and you put your money there．Then the waiter or waitress brings you your change.

    Which statement is true?

    A.American people like sitting with people they don't kno
    B.A hostess always seats a small group at a large tabl
    C.American people never sit with people they don't kno
    D.American people would not light a cigarette if the people who sit at the same table mind their smokin

    答案：D
    解析：
    参见第一段最后一句。

  • 第15题：

    In the US,people prefer waiting for a table to sitting with people they don't know．This means a hostess may not seat a small group until a small table is available,even if a large one is．If you are sitting at a table with people you don't know,it is impolite to light up a cigarette without first asking if it will disturb them.
    At American restaurants and coffee shops you are usually served tap water before you order．You may find the bread and butter is free,and if you order coffee,you may get a free refill.
    Most cities and towns have no roles about opening and closing times for stores or restaurants,though they usually do make rules for bars．Especially in large cities,stores may be open 24 hours a day．
    Servings in restaurants are often large,too large for many people．If you can't finish your meal but would like to enjoy the food later,ask your waitress or waiter for a"doggie bag"．It may have a picture of a dog on it,but everybody knows you are taking food for yourself.
    Supper and dinner are both words for the evening meal．Some people have"Sunday dinner"．This is an especially big noon meal.
    Tips are not usually added to the check．They are not included in the price of the meal,either．A tip of about 15%is expected and you should leave it on the table when you leave．In some restaurants,a check is brought on a plate and you put your money there．Then the waiter or waitress brings you your change.

    What do American people always do when servings are too large for them?

    A.They take the food home with a doggie bag for their dog
    B.They leave the food on the table and go awa
    C.They take the food home with a doggie bag and enjoy the food late
    D.They ask the waitress or waiter to keep the food for the

    答案：C
    解析：
    参见第四段。

  • 第16题：

    While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

    • A、A primary key must have been created.
    • B、A mapping table must have been created.
    • C、An overflow tablespace must have been specified.
    • D、The PCTTHRESHOLD option must have been specified.

    正确答案:B

  • 第17题：

    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

    • A、The Automatic Memory Manager (AMM)
    • B、The SQL Tuning Advisor
    • C、The Segment Advisor
    • D、The SQL Access Advisor

    正确答案:D

  • 第18题：

    You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 =  You need to provide maximum query performance. Table1 must remain available to users. What should you do？（）

    • A、Update all statistics on Table1 in DB1.
    • B、Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.
    • C、Set the priority boost server option to 1.
    • D、Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO

    正确答案:D

  • 第19题：

    单选题
    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
    A

    The Automatic Memory Manager (AMM)

    B

    The SQL Tuning Advisor

    C

    The Segment Advisor

    D

    The SQL Access Advisor SQL


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

  • 第20题：

    单选题
    You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）
    A

    Tab canvas. 

    B

    Pop up canvas. 

    C

    Spread table canvas. 

    D

    Vertical toolbar canvas.


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

  • 第21题：

    单选题
    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

     Export and import the mapping table.

    B

     Drop and re-create the mapping table.

    C

     Truncate the mapping table and reinsert the values.

    D

     Use the ALTER TABLE .. REBUILD command to defragment the mapping table.


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

  • 第22题：

    单选题
    My parents want very much to see you, and as we live in a very large house, we could offer you spacious accommodations.
    A

    criminal      

    B

    pump          

    C

    psychology      

    D

    lodgings


    正确答案： A
    解析：
    accommodation膳宿，住处。lodging住所。criminal罪犯。pump水泵。psychology心理学。

  • 第23题：

    单选题
    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
    A

    enable index monitoring and query the DBA_OBJECTS view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


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

相关内容