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

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


相似考题
更多“Which three operations can be performed as multipartition operations in Oracle?() ”相关问题
  • 第1题:

    Which two client requests are captured during database replay Capture?()

    A. Flashback queries

    B. Shared server requests

    C. Login and logoff activities of sessions

    D. Direct path load of data from external files by using utilities such as SQL *loader

    E. Data definition language (DDL) and data manipulation language (DML) operations


    参考答案:C, E

  • 第2题:

    Offer techniques for sharing business and technical metadata.

    Optimization/Operations

    简述共享业务元数据和技术元数据的方法。


    正确答案:
    答:为了能共享各种元数据,在数据仓库的构建过程中必须要有一些元数据标准,并在实际开发中遵守这些标准。这些标准包括元数据命名规则、存储规则及共享规则等内容。有关元数据标准的内容可以参看公共仓库元模型(Common Warehouse Metamodel,CWM)的相关资料 。
    在最基本的层面上,企业应该在下面三个方面制定好标准。
    1.命名规则
    命名规则应该在ETL组开始编码前制定好,范围包括表、列、约束、索引等等数据库对象以及其他一些编码规则。如果企业有自己的命名规则,ETL组应该遵守企业的命名规则。当企业的命名规则不能完全满足需求时,ETL组可以制定补充规则或者新的规则。对企业命名规则的改变需要有详细的文档记录,并提交企业相关部门审核。
    2.架构
    在ETL组开始工作前,架构应该先被设计好。例如ETL引擎是和数据仓库放在同一台服务器上还是单独设立服务器;数据准备区是建立成临时的还是持久的;数据仓库是基于维度建模的还是3NF建模的。并且这些内容应该有详细的文档记录。
    3.基础结构
    系统的基础结构也应该先确定好。例如解决方案是基于Windows的还是基于UNIX的。这些企业基础结构元数据应该在ETL组开始工作前制定好。这些内容也应该有详细的文档记录。
    在ETL的开发中,制定好元数据标准并能很好的遵守,那么建立好的数据仓库的元数据就可以很好的完成共享功能。

  • 第3题:

    An instruction is made up of(41) that specify the function to be performed and operands that represent the data to be operated on. For example, if an instruction is to perform. the operation of(42) two numbers, it must know(43) the two numbers are. The processor's job is to(44) instructions and operands from memory and to perform. each operation. Having done that, it signals(45) to send it next instruction.

    A.data

    B.address

    C.register

    D.operations


    正确答案:D

  • 第4题:

    Which two client requests are captured during database replay Capture?() (Choose two)

    A. Flashback queries

    B. Shared server requests

    C. Login and logoff activities of sessions

    D. Direct path load of data from external files by using utilities such as SQL *loader

    E. Data definition language (DDL) and data manipulation language (DML) operations


    参考答案:C, E

  • 第5题:

    Operations( )is a document that describes in detail the processes。

    A.Paper

    B.Book

    C.Menu

    D.Manual


    正确答案:D

  • 第6题:

    WhichthreestatementsregardingCiscoASAmulticastroutingsupportarecorrect?()

    A.ASAsupportsbothstubmulticastroutingandPIMmulticastrouting.However,youcannotconfigurebothconcurrentlyonasinglesecurityappliance

    B.Whenconfiguredforstubmulticastrouting,theASAcanactastheRendezvousPoint(RP)

    C.IftheASAdetectsIGMPversion1routers,theASAwillautomaticallyswitchtoIGMPversion1operations.

    D.TheASAsupportsbothPIM-SMandbi-directionalPIM

    E.EnablingmulticastroutinggloballyontheASAautomaticallyenablesPIMandIGMPonallinterfaces

    F.TheASAcanbeconfiguredforIGMPsnoopingtoconstrainthefloodingofmulticasttrafficbydynamicallyconfiguringthemulticasttraffictobeforwardedonlythoseinterfacesassociatedwithhostsrequestingthemulticastgroup


    参考答案:A, D, E