多选题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

题目
多选题
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

参考答案和解析
正确答案: C,E
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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


参考答案:A, B, F

第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?()

  • 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

正确答案:B

第3题:

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.


参考答案:B, C

第4题:

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.

正确答案:D

第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?()

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

正确答案:B

第6题:

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.

正确答案:C

第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?()

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

正确答案:C

第8题:

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


参考答案:B

第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?()

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

正确答案:B

第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?()

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

正确答案:D

更多相关问题