PARTITION BY HASH and ORGANIZE BY
PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE
PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE
PARTITION BY RANGE and ORGANIZE BY
第1题:
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?()
第2题:
Which data organization schemes are supported?()
第3题:
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.
第4题:
Which of the following explains the relationship between a physical and logical partition?()
第5题:
Which is a restriction on a list partitioned table?()
第6题:
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?()
第7题:
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?()
第8题:
A.A syntax error will result as you cannot specify more than one partition in the same statement
B.All data in p1 and p3 partitions are removed and the table definition is changed
C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D.Only the first partition (p1) will be dropped as only one can be dropped at any time
第9题:
After purchasing the Active Memory Expansion (AME) Enablement Feature,what tasks must be completed before AME can be used?()
第10题:
If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? ()