单选题In which cases is reference partitioning effective in enhancing performance?（）A It is effective only in partition pruning.B It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C It is e

题目
单选题
In which cases is reference partitioning effective in enhancing performance?（）
A

It is effective only in partition pruning.

B

It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

C

It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

D

It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

相似考题

1.It can be inferred in lesson four that the most effective way of enhancing your interview performance is to keep practicing.()

2.Which two statements are true regarding partitioning in Mysql?()A.Tables with BLOB and TEXT columns cannot be partitionedB.Partitioning allows easier management of smaller data sets for certain queriesC.Partitioning allows different columns to be stored in separate filesD.The partitioning expression is an integer or function that returns an integer value or NULL valueE.Partitioning is only available for those storage engines that implements it natively

3.Roman control was only effective in（）.AScotlandBWalesCLondonDThe southeast of Britain

4.In which cases is reference partitioning effective in enhancing performance?()A. It is effective only in partition pruning.B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

更多“单选题In which cases is reference partitioning effective in enhancing performance?（）A It is effective only in partition pruning.B It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C It is e”相关问题

  • 第1题：

    Using the following information: Performance data from an existing system that a new system will replace; Performance estimates that anticipate future workloads; Micro-partitioning and logical partitioning implementations. Which of the following allows a technical sales representative to create a system design which can be imported into an HMC?（）

    • A、IBMeConfig
    • B、IBM Performance Monitor
    • C、IBM Workload Estimator (WLE)
    • D、IBM System Planning Tool (SPT)

    正确答案:D

  • 第2题：

    Which of the following is an advantage of a virtualized server environment？（）

    • A、 Higher administrative complexity
    • B、 Increased level of security
    • C、 More effective usage of computing resources
    • D、 Improved performance for users

    正确答案:C

  • 第3题：

    What does the "allow performance information collection" button do in the Hardware Management Console （HMC） GUI？ （）

    • A、 It allows you to get inter partition reports， or cross partition performance activity.
    • B、 It will allow IBM remote technical support to get performance information from the machine.
    • C、 It is effective only on POWER6 and when Live Partition Mobility operations are planned.
    • D、 It will start standard performance monitoring tools when an LPAR boots up， the output will be saved to the /etc/perf directory by default.

    正确答案:A

  • 第4题：

    In which cases is reference partitioning effective in enhancing performance?（）

    • A、It is effective only in partition pruning.
    • B、It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
    • C、It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
    • D、It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

    正确答案:D

  • 第5题：

    Which statements are true regarding system-partitioned tables？（）  

    • A、 Only a single partitioning key column can be specified.
    • B、 All DML statements must use partition-extended syntax.
    • C、 The same physical attributes must be specified for each partition.
    • D、 Unique local indexes cannot be created on a system-partitioned table.
    • E、 Traditional partition pruning and partitionwise joins are not supported on these tables.

    正确答案:D,E

  • 第6题：

    Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）

    • A、Implement horizontal partitioning.
    • B、Implement vertical partitioning.
    • C、Implement a raw partition.
    • D、Implement distributed partitioning.

    正确答案:A

  • 第7题：

    多选题
    What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)
    A

    It cannot generate recommendations that support multiple workload queries.

    B

    It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

    C

    It can recommend partitioning only on tables that have at least 10,000 rows.

    D

    It can recommend only B-tree indexes and not bitmap or function-based indexes


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

  • 第8题：

    单选题
    What does the "allow performance information collection" button do in the Hardware Management Console （HMC） GUI？ （）
    A

     It allows you to get inter partition reports， or cross partition performance activity.

    B

     It will allow IBM remote technical support to get performance information from the machine.

    C

     It is effective only on POWER6 and when Live Partition Mobility operations are planned.

    D

     It will start standard performance monitoring tools when an LPAR boots up， the output will be saved to the /etc/perf directory by default.


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

  • 第9题：

    单选题
    In which cases is reference partitioning effective in enhancing performance？（）
    A

     It is effective only in partition pruning.

    B

     It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

    C

     It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

    D

     It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.


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

  • 第10题：

    单选题
    Which of the following is an advantage of a virtualized server environment?（）
    A

    Higher administrative complexity

    B

    Increased level of security

    C

    More effective usage of computing resources

    D

    Improved performance for users


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

  • 第11题：

    单选题
    Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）
    A

    Implement horizontal partitioning.

    B

    Implement vertical partitioning.

    C

    Implement a raw partition.

    D

    Implement distributed partitioning.


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

  • 第12题：

    单选题
    Using the following information: Performance data from an existing system that a new system will replace; Performance estimates that anticipate future workloads; Micro-partitioning and logical partitioning implementations.  Which of the following allows a technical sales representative to create a system design which can be imported into an HMC?（）
    A

    IBM eConfig

    B

    IBM Performance Monitor

    C

    IBM Workload Estimator (WLE)

    D

    IBM System Planning Tool (SPT)


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

  • 第13题：

    Roman control was only effective in（）.

    • A、Scotland
    • B、Wales
    • C、London
    • D、The southeast of Britain

    正确答案:D

  • 第14题：

    Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）

    • A、The cursor is only protected from updates and deletes by concurrent applications.
    • B、The row is only protected from positioned updates and deletes that reference another cursor of the same application.
    • C、The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
    • D、The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

    正确答案:A

  • 第15题：

    Which two statements are true regarding partitioning in Mysql?（）

    • A、Tables with BLOB and TEXT columns cannot be partitioned
    • B、Partitioning allows easier management of smaller data sets for certain queries
    • C、Partitioning allows different columns to be stored in separate files
    • D、The partitioning expression is an integer or function that returns an integer value or NULL value
    • E、Partitioning is only available for those storage engines that implements it natively

    正确答案:B,E

  • 第16题：

    What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

    • A、It cannot generate recommendations that support multiple workload queries.
    • B、It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
    • C、It can recommend partitioning only on tables that have at least 10,000 rows.
    • D、It can recommend only B-tree indexes and not bitmap or function-based indexes

    正确答案:B,C

  • 第17题：

    What two statements are true regarding the recommendations received from the SQL Access Advisor？（）

    • A、 It cannot generate recommendations that support multiple workload queries.
    • B、 It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
    • C、 It can recommend partitioning only on tables that have at least 10，000 rows.
    • D、 It can recommend only B-tree indexes and not bitmap or function-based indexes.

    正确答案:B,C

  • 第18题：

    单选题
    In which cases is reference partitioning effective in enhancing performance?（）
    A

    It is effective only in partition pruning.

    B

    It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

    C

    It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

    D

    It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.


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

  • 第19题：

    单选题
    Roman control was only effective in（）.
    A

    Scotland

    B

    Wales

    C

    London

    D

    The southeast of Britain


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

  • 第20题：

    多选题
    Which two statements are true regarding partitioning in Mysql?（）
    A

    Tables with BLOB and TEXT columns cannot be partitioned

    B

    Partitioning allows easier management of smaller data sets for certain queries

    C

    Partitioning allows different columns to be stored in separate files

    D

    The partitioning expression is an integer or function that returns an integer value or NULL value

    E

    Partitioning is only available for those storage engines that implements it natively


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

  • 第21题：

    单选题
    Which statement about firefighting foam is TRUE?（）
    A

    Foam conducts electricity

    B

    To be most effective，foam should be directed at the base of the fire

    C

    Foam is most effective on burning liquids which are flowing

    D

    Foam can ONLY be used to extinguish class A fires


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

  • 第22题：

    单选题
    Which of the following features sets IBM apart from competitors in the area of partitioning？（）
    A

    Software support

    B

    Hardware isolation

    C

    Static changes in partitions

    D

    Micro-Partitioning


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

  • 第23题：

    多选题
    Which statements are true regarding system-partitioned tables?（）
    A

    Only a single partitioning key column can be specified.

    B

    All DML statements must use partition-extended syntax.

    C

    The same physical attributes must be specified for each partition.

    D

    Unique local indexes cannot be created on a system-partitioned table.

    E

    Traditional partition pruning and partitionwise joins are not supported on these tables.


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

  • 第24题：

    单选题
    Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）
    A

    The cursor is only protected from updates and deletes by concurrent applications.

    B

    The row is only protected from positioned updates and deletes that reference another cursor of the same application.

    C

    The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

    D

    The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.


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

相关内容