多选题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 range-partitioned tableERename partitions of a range partitioned tableFMerge partitions of a reference partitioned index
多选题
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
参考解析
解析：
暂无解析
相关考题：
Evaluate the following statements:What are the two consequences of the above statements?() 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.
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
Which three operations can be performed as multipartition operations in Oracle?() A. Merge partitions of a list partitioned tableB. Drop partitions of a list partitioned tableC. Coalesce partitions of a hash-partitioned global index.D. Move partitions of a range-partitioned tableE. Rename partitions of a range partitioned tableF. Merge partitions of a reference partitioned index
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.
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 speedB、p670. Maximum partitions， maximum memory， number of I/O slotsC、p655. Maximum number of CPUs， processor speed， number of I/O slotsD、p690. Maximum number of CPUs， peak system bandwidth， peak I/O bandwidth
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.
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、1B、2C、3D、4
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 libraryconnection 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.
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.
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 EthernetB、Shared Ethernet AdapterC、Dedicated ProcessorsD、Shared Processor Pool
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.
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.
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.
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.
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.
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.
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.
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 columnE、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.
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.
For which of the following can you use Segment Shrink？（）A、 Heap tablesB、 Tables with function-based indexesC、 IndexesD、 Partitions and subpartitionsE、 None of the above
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
Which three operations can be performed as multipartition operations in Oracle?（）A、Merge partitions of a list partitioned tableB、Drop partitions of a list partitioned tableC、Coalesce partitions of a hash-partitioned global index.D、Move partitions of a range-partitioned tableE、Rename partitions of a range partitioned tableF、Merge partitions of a reference partitioned index
多选题In which two environments would intra-partition parallelism be used? （）ASingle database partition, single processorBSingle database partition, multiple processorsCMultiple database partitions, single processorDMultiple database partitions, multiple processors
多选题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?（）AUsing 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.BUsing 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.CUsing a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.DConverting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnEUsing 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.FUsing 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.
单选题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？（）A1B2C3D4
多选题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?（）AThe partitions can be moved online to new tablespaces.BGlobal indexes must be rebuilt manually after moving the partitions.CThe partitions can be compressed in the same tablespaces.DThe partitions can be compressed in the new tablespaces.ELocal indexes must be rebuilt manually after moving the partitions.
多选题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 range-partitioned tableERename partitions of a range partitioned tableFMerge partitions of a reference partitioned index
单选题Company.com with limited AIX skills has purchased a p5-520 2-way which will run Micro-Partitions. To reduce the initial cost of purchase， the customer will be sharing the system resources using a VIO server. The customer is concerned about managing the installation of the operating system. Which of the following should the customer perform？（）AUse alt_disk_install to install AIX on all logical partitions.BConfigure the DVD as a desired resource on all partitions.CConfigure all resources as shared resources between all partitions.DCreate a separate NIM server to manage the installation of all partitions.