网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
Which data organization schemes are supported?（）
A

PARTITION BY HASH and ORGANIZE BY  

B

PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE  

C

PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE 

D

PARTITION BY RANGE and ORGANIZE BY

参考答案

参考解析
解析： 暂无解析
更多 “单选题Which data organization schemes are supported?（）A PARTITION BY HASH and ORGANIZE BY  B PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE  C PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE D PARTITION BY RANGE and ORGANIZE BY” 相关考题
考题 Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?() A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
查看答案
考题 Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?() A.A syntax error will result as you cannot specify more than one partition in the same statementB.All data in p1 and p3 partitions are removed and the table definition is changedC.All data in p1 and p3 partitions are removed, but the table definition remains unchangedD.Only the first partition (p1) will be dropped as only one can be dropped at any time
查看答案
考题 Company.com has recently received a new p5-570 in the data center and intends to Micro-Partition the server. In which order should installation steps be taken？（）A、Connect to the network,power on the server,Micro-Partition the serverB、Connect to the HMC,power on the server,Micro-Partition the server,connect to the networkC、Power on server,connect to the network,Micro-Partition the server,connect to the HMCD、Power on the server,connect to the HMC,Micro-Partition the server,connect to the network
查看答案
考题 An administrator has set up three partitions using a shared processor pool with 2 processors and SMT turned on. The partitions are activated in the following sequence: Partition one: Min = 0.5, max = 3.0, desired = 1.0; Partition two: Min = 1.0, max = 3.0, desired = 1.5 Partition three: Min = 1, max = 0.5, desired = 2. What is the outcome?（）A、Partition one starts and has 3.0 logical processors. Partition two does not start. Partition three has 1.0 logical processors. B、Partition one starts and has 1.5 logical processors. Partition two has 1.0 logical processors. Partition three has 0.1 processors. C、Partition one starts and has 2.0 logical processors. Partition two start and has 2.0 logical processors. Partition three does not start. D、Partition one starts and has 2.0 logical processors. Partition two has 1.0 logical processors. Partition three has 0.1 logical processors.
查看答案
考题 Which data organization schemes are supported?（）A、PARTITION BY HASH and ORGANIZE BY  B、PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE  C、PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE D、PARTITION BY RANGE and ORGANIZE BY
查看答案
考题 You need to create a partitioned table to store historical data and you issued the following command：   CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’）））  AS SELECT * FROM purchases WHERE time_id  TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；   What is the outcome of the above command？（）  A、 It returns an error because the range partitions P1 and P2 should be of the same range.B、 It creates two range partitions （P1， P2）. Within each range partition， it creates monthwise subpartitions.C、 It creates two range partitions of varying range. For data beyond ’1-1-2007，’ it creates partitions with a width of one month each.D、 It returns an error because the number of tablespaces （TBS1，TBS2，TBS3）specified does not match the number of range partitions （P1，P2） specified.
查看答案
考题 Which is a restriction on a list partitioned table？（）A、You cannot create global range partitioned indexes on the table. B、The optimizer will not execute partition wise joins on the table’s partitions. C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.
查看答案
考题 After purchasing the Active Memory Expansion （AME） Enablement Feature，what tasks must be completed before AME can be used？（）A、Enable using active partition properties with DLPARB、Enter the activation key via the AIX 6.1 command line and reboot AIXC、Enter the activation key via the HMC,power cycle the managed system and start the LPARD、Enter the activation key via the HMC,modify the partition profile and restart the LPAR
查看答案
考题 Which of the following explains the relationship between a physical and logical partition?（）A、A physical partition is hosted on one or more logical partitions. A logical partition is used when describing storage.B、A logical partition is hosted on one or more physical partitions. A physical partition is used when describing storage.C、A physical partition is used when describing only a SCSI or SAS disk. A logical partition is used when describing a SAN LUN.D、A logical partition is used when describing only a SATA or SAS disk. A physical partition is used when describing RAID or mirrored arrays.
查看答案
考题 If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）A、All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  B、Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  C、Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  D、A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
查看答案
考题 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 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.
查看答案
考题 Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A、A syntax error will result as you cannot specify more than one partition in the same statementB、All data in p1 and p3 partitions are removed and the table definition is changedC、All data in p1 and p3 partitions are removed, but the table definition remains unchangedD、Only the first partition (p1) will be dropped as only one can be dropped at any time
查看答案
考题 Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  A、 It executes successfully but partition pruning cannot happen for this partition key.B、 It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C、 It produces an error because compression cannot be used for the TOTAL_VALUE partition key. D、 It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
查看答案
考题 单选题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.
查看答案
考题 单选题An administrator has set up three partitions using a shared processor pool with 2 processors and SMT turned on. The partitions are activated in the following sequence: Partition one: Min = 0.5, max = 3.0, desired = 1.0; Partition two: Min = 1.0, max = 3.0, desired = 1.5 Partition three: Min = 1, max = 0.5, desired = 2. What is the outcome?（）A Partition one starts and has 3.0 logical processors. Partition two does not start. Partition three has 1.0 logical processors. B Partition one starts and has 1.5 logical processors. Partition two has 1.0 logical processors. Partition three has 0.1 processors. C Partition one starts and has 2.0 logical processors. Partition two start and has 2.0 logical processors. Partition three does not start. D Partition one starts and has 2.0 logical processors. Partition two has 1.0 logical processors. Partition three has 0.1 logical processors.
查看答案
考题 单选题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 of the following explains the relationship between a physical and logical partition?（）A A physical partition is hosted on one or more logical partitions. A logical partition is used when describing storage.B A logical partition is hosted on one or more physical partitions. A physical partition is used when describing storage.C A physical partition is used when describing only a SCSI or SAS disk. A logical partition is used when describing a SAN LUN.D A logical partition is used when describing only a SATA or SAS disk. A physical partition is used when describing RAID or mirrored arrays.
查看答案
考题 单选题Which data organization schemes are supported?（）A PARTITION BY HASH and ORGANIZE BY  B PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE  C PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE D PARTITION BY RANGE and ORGANIZE BY
查看答案
考题 单选题After purchasing the Active Memory Expansion （AME） Enablement Feature，what tasks must be completed before AME can be used？（）A Enable using active partition properties with DLPARB Enter the activation key via the AIX 6.1 command line and reboot AIXC Enter the activation key via the HMC,power cycle the managed system and start the LPARD Enter the activation key via the HMC,modify the partition profile and restart the LPAR
查看答案
考题 单选题Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）A  It executes successfully but partition pruning cannot happen for this partition key.B  It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C  It produces an error because compression cannot be used for the TOTAL_VALUE partition key. D  It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
查看答案
考题 单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A A syntax error will result as you cannot specify more than one partition in the same statementB All data in p1 and p3 partitions are removed and the table definition is changedC All data in p1 and p3 partitions are removed, but the table definition remains unchangedD Only the first partition (p1) will be dropped as only one can be dropped at any time
查看答案
考题 单选题Company.com has recently received a new p5-570 in the data center and intends to Micro-Partition the server. In which order should installation steps be taken？（）A Connect to the network,power on the server,Micro-Partition the serverB Connect to the HMC,power on the server,Micro-Partition the server,connect to the networkC Power on server,connect to the network,Micro-Partition the server,connect to the HMCD Power on the server,connect to the HMC,Micro-Partition the server,connect to the network
查看答案
考题 单选题You need to create a partitioned table to store historical data and you issued the following command：   CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’）））  AS SELECT * FROM purchases WHERE time_id  TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；   What is the outcome of the above command？（）A  It returns an error because the range partitions P1 and P2 should be of the same range.B  It creates two range partitions （P1， P2）. Within each range partition， it creates monthwise subpartitions.C  It creates two range partitions of varying range. For data beyond ’1-1-2007，’ it creates partitions with a width of one month each.D  It returns an error because the number of tablespaces （TBS1，TBS2，TBS3）specified does not match the number of range partitions （P1，P2） specified.
查看答案
考题 单选题If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）A All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  B Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  C Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  D A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
查看答案
考题 多选题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.
查看答案
考题 单选题You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）A  Set DYNAMIC_SAMPLING to level 4B  Set the STATISTICS_LEVEL parameter to BASICC  Set the INCREMENTAL value to TRUE for the partition tableD  Increase the value of STALE_PERCENT for the partition table
查看答案
考题 单选题Which is a restriction on a list partitioned table？（）A You cannot create global range partitioned indexes on the table. B The optimizer will not execute partition wise joins on the table’s partitions. C You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. D Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.
查看答案
热门标签
最新试卷