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 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.
相关考题：
It can be inferred in lesson four that the most effective way of enhancing your interview performance is to keep practicing.()
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.
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
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、IBMeConfigB、IBM Performance MonitorC、IBM Workload Estimator (WLE)D、IBM System Planning Tool (SPT)
Which of the following is an advantage of a virtualized server environment？（）A、 Higher administrative complexityB、 Increased level of securityC、 More effective usage of computing resourcesD、 Improved performance for users
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.
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.
Which of the following features sets IBM apart from competitors in the area of partitioning？（）A、Software supportB、Hardware isolationC、Static changes in partitionsD、Micro-Partitioning
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
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
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.
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.
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.
单选题In which cases is reference partitioning effective in enhancing performance?（）AIt is effective only in partition pruning.BIt is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.CIt is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.DIt 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.
多选题What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.CIt can recommend partitioning only on tables that have at least 10,000 rows.DIt can recommend only B-tree indexes and not bitmap or function-based indexes
单选题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.
多选题Which two statements are true regarding partitioning in Mysql?（）ATables with BLOB and TEXT columns cannot be partitionedBPartitioning allows easier management of smaller data sets for certain queriesCPartitioning allows different columns to be stored in separate filesDThe partitioning expression is an integer or function that returns an integer value or NULL valueEPartitioning is only available for those storage engines that implements it natively
单选题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.
单选题Which statement about firefighting foam is TRUE?（）AFoam conducts electricityBTo be most effective，foam should be directed at the base of the fireCFoam is most effective on burning liquids which are flowingDFoam can ONLY be used to extinguish class A fires
单选题Which of the following is an advantage of a virtualized server environment？（）A Higher administrative complexityB Increased level of securityC More effective usage of computing resourcesD Improved performance for users
问答题Topic 6：Can shopping vouchers increase consumption? Questions for Reference: 1) To stimulate consumption, which is more effective, tax reduction or shopping vouchers? 2) What are the major purposes of issuing shopping vouchers? 3) In what way can the shopping vouchers best be distributed? Shall every citizen be given the same amount of shopping vouchers or should the vouchers be limited to the lower-income people only?
多选题Which statements are true regarding system-partitioned tables?（）AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique local indexes cannot be created on a system-partitioned table.ETraditional partition pruning and partitionwise joins are not supported on these tables.
问答题Q5: Apart from appraisal schemes, what other measures do you think are effective improving staff performance? (Why?)
单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）AThe cursor is only protected from updates and deletes by concurrent applications.BThe row is only protected from positioned updates and deletes that reference another cursor of the same application.CThe cursor is protected from positioned updates and deletes that reference another cursor of a different application.DThe 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.