Merge partitions of a list partitioned table
Drop partitions of a list partitioned table
Coalesce partitions of a hash-partitioned global index.
Move partitions of a range-partitioned table
Rename partitions of a range partitioned table
Merge partitions of a reference partitioned index
第1题:
A. Merge partitions of a list partitioned table
B. Drop partitions of a list partitioned table
C. Coalesce partitions of a hash-partitioned global index.
D. Move partitions of a range-partitioned table
E. Rename partitions of a range partitioned table
F. Merge partitions of a reference partitioned index
第2题:
An HP customer would like to discuss IBM system advantages. Their current system platform is a partitioned HP rp8400. Which of the following pSeries systems and advantages should be discussed?()
第3题:
A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
第4题:
Which of the following statements is TRUE about the reorgvg command?()
第5题:
What is the minimum number of virtual I/O server partitions needed to ensure high availability of the disks when utilizing the Virtual I/O server in a micro-partitioned solution?()
第6题:
Which is a restriction on a list partitioned table?()
第7题:
Company.com wants to create four partitions on a pSeries p5-570 8-way with one SCSI PCI adapter connected to an external LTO tape drive. The partitions are to be created from an existing system image backup tape. Which of the following actions will enable the creation of the partitions with minimal intervention?()
第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题:
A system is being planned with three production partitions, one each for an IBM i, AIX standard edition, and Power Linux applications. One fibre-channel attached TS3100 tape library will be shared between the partitions for backup. Which solution provides tape library sharing with minimum operator intervention?()
第10题:
Company.com has purchased a 2-way p5-520 and would like to create three Micro-Partitions on the server. Which feature of Advanced POWER Virtualization would allow them to create the desired number of partitions?()