多选题Which three operations can be performed as multipartition operations in Oracle?（）AMerge partitions of a list partitioned tableBDrop partitions of a list partitioned tableCCoalesce partitions of a hash-partitioned global index.DMove partitions of a rang

第1题：

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？（）

• A、p630. Maximum partitions， maximum storage， I/O bus speed
• B、p670. Maximum partitions， maximum memory， number of I/O slots
• C、p655. Maximum number of CPUs， processor speed， number of I/O slots
• D、p690. Maximum number of CPUs， peak system bandwidth， peak I/O bandwidth

第2题：

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？（）

• A、1
• B、2
• C、3
• D、4

第3题：

Which of the following statements is TRUE about the reorgvg command?（）

• A、No logical volumes wil be moved if write-verify is set to yes.
• B、No action will be performed if it cannot fulfill the allocation requirements.
• C、Physical partitions of a logical volume will be moved if the logical volume's relocatable flag is set to "no".
• D、Physical partitions will be moved as close as possible to the positions specified, if the allocation requirements cannot be fulfilled.

第4题：

Company.com has a p5-570 with an application running on each of three Micro-Partitions. The disk I/O is shared through a VIO server. A technical specialist has been asked to upgrade the VIO  server. Which of the following procedures should be taken to maintain the integrity of the partitions？（）

• A、Shut down all client partitions before updating the VIO server.
• B、Disconnect the client partitions from any IP networks before updating the VIO server.
• C、Update the client partitions to the latest OS maintenance level before updating the VIO Server.
• D、Update the VIO server while the partitions are running， but reboot each client partition at a convenient time after the update.

第5题：

Companycom wants to manage multiple partitions for a p5 590 server using Partition Load Manager (PLM). Some of the partitions are dedicated processors and some of them are shared processors. What information about PLM limitations should be expressed to the customer?（） 

• A、All of the partitions can be managed in one group mixing dedicated and shared processors. PLM will move resources in the group as setup in the PLM profiles. 
• B、PLM handles memory, dedicated and shared processor partitions. All the partitions in a group must be of the same processor type. PLM moves I/O resources between partitions based on PLM policy files. 
• C、PLM handles memory, dedicated and shared processor partitions. The policy file, once loaded, is static and has no knowledge of workload on the managed partitions. PLM is supported for partitions that are running AIX 5.2 or i5OS. 
• D、All of the partitions in a group must be the same type, either all dedicated processor partitions or shared processor partitions. One PLM Server can manage multiple groups of partitions. PLM does not move resources between groups.

第6题：

What is the objective of the superstrict option that can be used when creating mirrors?（）

• A、Allows the mirror partitions to spread across a maximum number of disks.
• B、Allows the copy of a partition to be on the same physical volume as the mirrored partition.
• C、Prevents partitions allocated to one logical volume mirror from sharing a physical volume with partitions from another logical volume mirror.
• D、Forces copies of logical partitions to be housed on different physical volumes, while allowing a single physical volume to be shared by logical volume mirrors.

第7题：

A customer is purchasing a 12-way p5-570 to run light development workloads on eight AIX 5.3 partitions with two network adapters each.  When the current network configuration was reviewed， it was discovered that they only have four Ethernet ports available on their network switch.  Which of the following solutions would prevent them from having to buy another network switch or hub？（）

• A、Add two HMCs with two Ethernet adapters each and run EtherChannel for the original eight partitions.
• B、Add two HMCs with two Ethernet adapters each and run Virtual Ethernet for the original eight partitions.
• C、Add two hosting partitions with two Ethernet adapters each and run EtherChannel for the original eight partitions.
• D、Add two hosting partitions with two Ethernet adapters each and run Virtual Ethernet for the original eight partitions.

第8题：

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?（）

• A、The partitions can be moved online to new tablespaces.
• B、Global indexes must be rebuilt manually after moving the partitions.
• C、The partitions can be compressed in the same tablespaces.
• D、The partitions can be compressed in the new tablespaces.
• E、Local indexes must be rebuilt manually after moving the partitions.

第9题：

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 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

第10题：

第11题：

第12题：

第13题：

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？（）

• A、Install a VIO partition to share the tape drive.
• B、Purchase three external SCSI adapters and physically move the tape drive when needed.
• C、Create the partition definitions with the SCSI adapter as a desired resource and use DLPAR commands to move the tape drive.
• D、Create the partition definitions with the SCSI adapter as a required resource for all partitions and use DLPAR commands to move the tape drive.

第14题：

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?（）

• A、Configure VIO Server Express Edition to control the tape library through one fibre channel card.Assign the  library to the production partitions when needed.
• B、Configure the IBM i partition to own the tape library.Use IBM i virtualization to host a virtual tape library  connection to the AIX and Linux partition.Assign the library to the production partitions when needed.
• C、Configure a fibre channel card for each partition， and a configure fibre switch.Connect the partitions and  tape library to the switch.Zone the switch so all partitions can enable the tape when needed and disable  the tape when finished.
• D、Configure AIX to control the tape library through one fibre channel adapter.Use AIX virtualization to host a  virtual tape library connection to the IBM i and Linux partitions.Assign the library to the production  partitions when needed.

第15题：

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？（）

• A、Virtual Ethernet
• B、Shared Ethernet Adapter
• C、Dedicated Processors
• D、Shared Processor Pool

第16题：

A company plans to deploy a two-enclosure, 23-core Power 780 system with AIX, IBM i and Linux in thefollowing configuration: 3 AIX partitions with dedicated network and disk adapters; 1 native IBM i partition acting as a host1 hosted IBM i partition; 2 hosted Linux partitions. Which configuration will provide boot disk capability to all partitions?（）

• A、Use dual-split backplane in both enclosures for the three AIX partitions and the IBMi partition.
• B、Put each partition on a dedicated controller using the triple-split backplane option in both enclosures.
• C、Use the triple-split backplane option in one enclosure for the AIX partitions, and the default dual-split  backplane for the IBMi partition in the second enclosure.
• D、Use the triple-split backplane option in one enclosure for the AIX partitions, and the non-split backplane  mode in the second enclosure for the IBMi hosting partition.

第17题：

Companycom tells the technical sales specialist that recent announcements state that virtual lan in the datacenter is the best option. The customer wants to use interpartition communication to save on adapters and increase performance. The systems are going to have shared and dedicated processor partitions. Some of the partitions will be running AIX 5.2 and some will be running AIX 5.3. The second p5 590 will be running a mixture of AIX 5.3 and Linux partitions with 2.6 kernel. What limitations of vlan/interpartition  communication should be discussed with this customer?（）

• A、Virtual Ethernet uses the system processors for all communication functions instead of offloading that load to processors on network adapter cards. Virtual Ethernet is supported on AIX 5L and Linux 2.5 and above. 
• B、Virtual Ethernet can be used within groups of shared OR groups of dedicated processor partitions, but not both simultaneously. Virtual Ethernet comes with AIX 5L, and is supported in AIX 5.2 or AIX 5.3 partitions, but not Linux. 
• C、Virtual Ethernet can be used in both shared and dedicated processor partitions. Virtual Ethernet can run in an AIX 5.3 or Linux 2.6 Kernel, but not AIX 5.2 partitions. Virtual Ethernet can only connect partitions within a single system. 
• D、Virtual Ethernet uses the system processors for all communication functions instead of offloading that load to processors on network adapter cards. Virtual Ethernet can connect partitions between systems if the HMC is shared between systems.

第18题：

A system administrator is implementing a new 2-way POWER5 server with APV that is to be divided into three partitions. The application groups have requested the following CPU entitlements for the partitions：  Partition 1： min = 1.0， max = 2.0， desired = 1.5  Partition 2： min = 1.0， max = 2.0， desired = 1.0  Partition 3： min = 0.1， max = 1.0， desired = 0.8  The administrator immediately finds that the three partitions cannot be started in order to run concurrently.  What changes can be made to entitlement configuration to allow all three partitions to be started in order？（）

• A、Change the max on Partition 1 to 1.5.
• B、Change the desired on Partition 1 to 1.0.
• C、Change the max and desired on Partition 1 and 2 to 1.0.
• D、Change the min and desired on Partition 1 and 2 to 0.9.

第19题：

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）

• A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
• E、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

第20题：

For which of the following can you use Segment Shrink？（）

• A、 Heap tables
• B、 Tables with function-based indexes
• C、 Indexes
• D、 Partitions and subpartitions
• E、 None of the above

第21题：

Which three operations can be performed as multipartition operations in Oracle?（）

• 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

第22题：

第23题：

第24题：