多选题Which statements are true regarding system-partitioned tables？（）AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique lo

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

相似考题

1.Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()A. A DBA can check specific tables with the DMUB. The database to be migrated must be opened read-only.C. The release of the database to be converted can be any release since 9.2.0.8.D. The DMU can report columns that are too long in the converted characterset.E. The DMU can report columns that are not represented in the converted characterset.

2.Which statements concerning the switch construct are true？（）  A、All switch statements must have a default label.B、There must be exactly one label for each code segment in a switch statement.C、The keyword continue can never occur within the body of a switch statement.D、No case label may follow a default label within a single switch statement.E、A character literal can be used as a value for a case label.

3.Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

4.Which of the following are true statements regarding the characteristics of OSPF areas? Select all that apply.()A. All OSPF networks require the use of multiple areasB. Multiple OSPF areas must connect to area 0C. Single area OSPF networks must be configured in area 1D. Areas can be assigned any number from 0 to 63535E. Area 0 is called the backbone areaF. Each OSPF area need to be configured with a loopback interface

更多“多选题Which statements are true regarding system-partitioned tables？（）AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique lo”相关问题

  • 第1题：

    Which statement is true regarding the INTERSECT operator?（）

    • A、It ignores NULL values 
    • B、Reversing the order of the intersected tables alters the result 
    • C、The names of columns in all SELECT statements must be identical 
    • D、The number of columns and data types must be identical for all SELECT statements in the query 

    正确答案:D

  • 第2题：

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

    正确答案:C

  • 第3题：

    Which statements are true regarding the Query Result Cache？（） 

    • A、 It can be set at the system， session， or table level.
    • B、 It is used only across statements in the same session.
    • C、 It can store the results from normal as well as flashback queries.
    • D、 It can store the results of queries based on normal，temporary，and dictionary tables.

    正确答案:A,C

  • 第4题：

    Which two statements are true regarding the ORDER BY clause? （）

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第5题：

    Which two statements about creating constraints are true? （）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level
    • C、Constraints can be created after the table is created
    • D、Constraints can be created at the same time the table is created
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

    正确答案:C,D

  • 第6题：

    多选题
    Which statements are valid for a local SPAN configuration？ （）
    A

    Source and destination interface must be on the same host

    B

    Source and destination interfaces can be on different hosts

    C

    Destination vEthernet interface can be on a different VLAN than the source

    D

    Destination interface can be a physical port

    E

    Destination interface cannot be a physical port


    正确答案： D,B
    解析： 暂无解析

  • 第7题：

    多选题
    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）
    A

    Only one LONG column can be used per table

    B

    A TIMESTAMP data type column stores only time values with fractional seconds

    C

    The BLOB data type column is used to store binary data in an operating system file

    D

    The minimum column width that can be specified for a VARCHAR2 data type column is one

    E

    The value for a CHAR data type column is blank-padded to the maximum defined column width


    正确答案： C,E
    解析： 暂无解析

  • 第8题：

    多选题
    An IPsec tunnel is established on an SRX Series Gateway on an interface whose IP address was obtained using DHCP.Which two statements are true? （）(Choose two.)
    A

    Only main mode can be used for IKE negotiation

    B

    A local-identity must be defined

    C

    It must be the initiator for IKE

    D

    A remote-identity must be defined


    正确答案： B,C
    解析： 暂无解析

  • 第9题：

    单选题
    Which statement is true regarding the INTERSECT operator?（）
    A

    It ignores NULL values 

    B

    Reversing the order of the intersected tables alters the result 

    C

    The names of columns in all SELECT statements must be identical 

    D

    The number of columns and data types must be identical for all SELECT statements in the query 


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    Which statements are true regarding the Query Result Cache？（）
    A

    It can be set at the system， session， or table level.

    B

    It is used only across statements in the same session.

    C

    It can store the results from normal as well as flashback queries.

    D

    It can store the results of queries based on normal，temporary，and dictionary tables.


    正确答案： A,C
    解析： 暂无解析

  • 第11题：

    多选题
    Which three statements are true regarding subqueries?（）
    A

    Subqueries can contain GROUP BY and ORDER BY clauses

    B

    Main query and subquery can get data from different tables

    C

    Main query and subquery must get data from the same tables

    D

    Subqueries can contain ORDER BY but not the GROUP BY clause

    E

    Only one column or expression can be compared between the main query and subquery

    F

    Multiple columns or expressions can be compared between the main query and subquery


    正确答案： B,D
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true regarding the ORDER BY clause? （）
    A

    It is executed first in the query execution

    B

    It must be the last clause in the SELECT statement

    C

    It cannot be used in a SELECT statement containing a HAVING clause

    D

    You cannot specify a column name followed by an expression in this clause

    E

    You can specify a combination of numeric positions and column names in this clause


    正确答案： E,C
    解析： 暂无解析

  • 第13题：

    Which three statements are true regarding subqueries?（）

    • A、Subqueries can contain GROUP BY and ORDER BY clauses 
    • B、Main query and subquery can get data from different tables 
    • C、Main query and subquery must get data from the same tables 
    • D、Subqueries can contain ORDER BY but not the GROUP BY clause 
    • E、Only one column or expression can be compared between the main query and subquery
    • F、 Multiple columns or expressions can be compared between the main query and subquery

    正确答案:A,B,E

  • 第14题：

    Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）

    • A、A DBA can check specific tables with the DMU
    • B、The database to be migrated must be opened read-only.
    • C、The release of the database to be converted can be any release since 9.2.0.8.
    • D、The DMU can report columns that are too long in the converted characterset.
    • E、The DMU can report columns that are not represented in the converted characterset.

    正确答案:A,D,E

  • 第15题：

    Which three statements describe the functionality of the DO_KEY built-in?（）

    • A、It accepts both a built-in and a key name as argument. 
    • B、If no key trigger is defined, the specified built-in executes. 
    • C、Its parameter must be specified in upper case, enclosed in single quotation marks. 
    • D、It performs the same task as if you pressed the function key associated with the specified argument. 
    • E、It executes the key trigger that corresponds to the built-in specified as its parameter. 

    正确答案:B,D,E

  • 第16题：

    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.

    正确答案:D,E

  • 第17题：

    Which two statements about creating constraints are true?（）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level.
    • C、Constraints can be created after the table is created.
    • D、Constraints can be created at the same time the table is created.
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

    正确答案:C,D

  • 第18题：

    多选题
    Which three statements describe the functionality of the DO_KEY built-in?（）
    A

    It accepts both a built-in and a key name as argument.

    B

    If no key trigger is defined, the specified built-in executes.

    C

    Its parameter must be specified in upper case, enclosed in single quotation marks.

    D

    It performs the same task as if you pressed the function key associated with the specified argument.

    E

    It executes the key trigger that corresponds to the built-in specified as its parameter.


    正确答案： B,D,E
    解析： 暂无解析

  • 第19题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    All constraints must be defines at the column level

    C

    Constraints can be created after the table is created

    D

    Constraints can be created at the same time the table is created

    E

    Information about constraints is found in the VIEW_CONSTRAINTS dictionary view


    正确答案： C,D
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    All constraints must be defines at the column level.

    C

    Constraints can be created after the table is created.

    D

    Constraints can be created at the same time the table is created.

    E

    Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.


    正确答案： A,E
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements are true regarding single row functions?（）
    A

    They accept only a single argument

    B

    They can be nested only to two levels

    C

    Arguments can only be column values or constants

    D

    They always return a single result row for every row of a queried table

    E

    They can return a data type value different from the one that is referenced


    正确答案： E,B
    解析： 暂无解析

  • 第23题：

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


    正确答案： B,D
    解析： 暂无解析

  • 第24题：

    多选题
    Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）
    A

    A DBA can check specific tables with the DMU

    B

    The database to be migrated must be opened read-only.

    C

    The release of the database to be converted can be any release since 9.2.0.8.

    D

    The DMU can report columns that are too long in the converted characterset.

    E

    The DMU can report columns that are not represented in the converted characterset.


    正确答案： B,C
    解析： 暂无解析

相关内容