-
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.
-
Which two statements are true regarding partitioning in Mysql?()
A . Tables with BLOB and TEXT columns cannot be partitioned
B . Partitioning allows easier management of smaller data sets for certain queries
C . Partitioning allows different columns to be stored in separate files
D . The partitioning expression is an integer or function that returns an integer value or NULL value
E . Partitioning is only available for those storage engines that implements it natively
-
Which server houses the database partitions in the AIX BCU V2.1? ()
A . IBM System p5 570
B . IBM System p5 575
C . IBM System p5 590
D . IBM System p5 595
-
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.
-
Which command will increase the contiguous free space of a file system without having to add additional partitions?()
A . chfs
B . fsck
C . chlv
D . defragf
-
When booting the p5 590 server in full system partition mode, which location is preferred for the fastest boot?()
A . A SAN device
B . First I/O drawer
C . Any I/O drawer within the main frame
D . First I/O drawer within the expansion frame
-
Which command should the administrator use to display the IPL progress/LED code of the partition?()
A . lsled -m System -r lpar
B . lsrefcode -m System -r lpar
C . lshwinfo -m System -r led_code
D . lssyscfg -m System -r sys -F lpar_name,led_code
-
Which of the following interfaces is required to implement Workload Partition Mobility? ()
A . Workload Partitions Manager for AIX
B . Hardware Management Console (HMC) GUI
C . Integrated Virtualization Manager (IVM)
D . Advanced System Management Interface (ASMI)
-
Which four vertical markets is IPsmartSuite focused?()
A . manufacturing
B . legal
C . healthcare
D . financial
E . automotive
F . retail
-
Which of the following is a correct statement about Workload Partitions (WPARs)?()
A . WPARs use dedicated cores and shared memory.
B . WPARs are restricted to using dedicated resources.
C . WPARs share the resources of a single AIX instance.
D . WPARs use shared cores, memory, and dedicated network adapters.
-
Which of the following is required to connect a partitioned p5-550 to a modem?()
A . A modem adapter
B . An async adapter and serial cable
C . An Ethernet adapter
D . A 9-pin to 25-pin converter and serial cable
-
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.
-
Which of the following statements is true regarding implementing Live Partition Mobility on two existing POWER6 based systems?()
A . The systems must use internal storage for boot purposes.
B . All virtualized ethernet adapters must be numbered below 10.
C . The mobile partition's network and disk access must be virtualized.
D . Each system must be controlled by a different Hardware Management Console (HMC).&e
-
Which one of the following provides the capability to partition the 3584 Tape Library into separatelogical libraries?()
A . Control Path Failover
B . Enhanced Frame Control
C . Advanced Library Management System
D . High Availability Library Control
-
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.
-
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 commands will show how many physical partitions are available on active hdisk1?()
A . lspv hdisk1
B . lsvg -p hdisk1
C . lsattr -p hdisk1
D . lsdev -E -l hdisk1
-
In which two environments would intra-partition parallelism be used? ()
A . Single database partition, single processor
B . Single database partition, multiple processors
C . Multiple database partitions, single processor
D . Multiple database partitions, multiple processor
-
Which four vertical markets is IPsmartSuite focused? ()
A . automotive
B . legal
C . healthcare
D . manufacturing
E . financial
F . retail
-
A pSeries technical specialist is designing a p5-550 LPAR solution which will contain four logical partitions. Which tool should be used to ensure adherence to all partition rules?()
A . LVT
B . eSAR
C . eConfig
D . PCRS6000
-
“A centrifuge consists of an electric motor driving a vertical shaft on the top of which is mounted the bowl assembly”.According to this sentence, we can know that is mounted on the top of the vertical shaft()
A . a centrifuge
B . an electric motor
C . a bowl assembly
D . a driving motor
-
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()
A . ALTER TABLE SPLIT PARTITION
B . ALTER TABLE MERGE PARTITION
C . ALTER TABLE TRUNCATE PARTITION
D . ALTER TABLE ADD PARTITION
E . ALTER TABLE DROP PARTITION
F . ALTER TABLE MOVE PARTITION
-
8. Which of the following is not true of “vertical integration”?
-
Which of the following is true of vertical marketing systems?
A、 Producers, wholesalers, and retailers act as a unified system.
B、 Channel members have no control over each other.
C、 Channel conflict is governed by informal mechanisms.
D、 The system is dominated by the consumer.
E、 Channel members work independently with no cooperation from other members.