多选题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.The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data

2.Which two statements are true regarding the role of the Routing Engine (RE)?()A. The RE controls and monitors the chassis.B. The RE manages the Packet Forwarding Engine (PFE).C. The RE receives a copy of the forwarding table from the forwarding plane.D. The RE implements class of service (COS).

3.Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

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

更多“Which statements are true regarding system-partitioned table”相关问题

  • 第1题：

    Which two statements are true regarding the role of the Routing Engine (RE)?（）

    • A、The RE controls and monitors the chassis.
    • B、The RE manages the Packet Forwarding Engine (PFE).
    • C、The RE receives a copy of the forwarding table from the forwarding plane.
    • D、The RE implements class of service (COS).

    正确答案:A,B

  • 第2题：

    The statements below compare and contrast link state and distance vector routing protocols. Which of these are true?（）

    • A、Distance vector protocols send the entire routing table to directly connected neighbors.
    • B、Distance vector protocols are responsible for sending updates to all networks listed in the routing table.
    • C、Link state protocols are responsible for sending the entire routing table to the whole network.
    • D、Link state protocols send updates regarding their own links status to all other routers on the network.

    正确答案:A,D

  • 第3题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

    • A、 All the related indexes and views are automatically dropped
    • B、 The flashback drop feature can recover only the table structure
    • C、 Only the related indexes are dropped whereas views are invalidated
    • D、 The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第4题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第5题：

    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

    • A、 An SCN is never used to perform a Flashback Table recovery.
    • B、 If a significant number of changes have been made to the table， row movement must be enabled.
    • C、 The tablespace must be offline before performing a Flashback Table recovery.
    • D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.

    正确答案:D

  • 第6题：

    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

    正确答案:D,E

  • 第7题：

    多选题
    Which two statements are true regarding the USING and ON clauses in table joins?（）
    A

    Both USING and ON clauses can be used for equijoins and nonequijoins

    B

    Amaximum of one pair of columns can be joined between two tables using the ON clause

    C

    The ON clause can be used to join tables on columns that have different names but compatible data types

    D

    The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause


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

  • 第8题：

    单选题
    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）
    A

     All the triggers are disabled.

    B

     All the triggers are enabled by default.

    C

     Enabled triggers remain enabled and disabled triggers remain disabled.

    D

     Triggers are deleted when a Flashback Table operation is performed.


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

  • 第9题：

    多选题
    Which two statements are true regarding routing tables?（）
    A

    The routing table is populated by the forwarding table.

    B

    Devices running the Junos OS can accommodate multiple routing tables.

    C

    Information learned from routing protocols is stored in the routing table.

    D

    The primary routing table for IPv4 unicast routes is inet.4.


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

  • 第10题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第11题：

    多选题
    Which two statements regarding the Flashback Table feature are correct?（）
    A

    Flashback Table can be performed on system tables.

    B

    Flashback Table operation does not shrink the segments.

    C

    Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

    D

    Flashback Table operation acquires exclusive data manipulation language (DML) locks.


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

  • 第12题：

    多选题
    Which two statements are true regarding the role of the Routing Engine (RE)?（）
    A

    The RE controls and monitors the chassis.

    B

    The RE manages the Packet Forwarding Engine (PFE).

    C

    The RE receives a copy of the forwarding table from the forwarding plane.

    D

    The RE implements class of service (COS).


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

  • 第13题：

    Which two statements are true regarding routing tables?（）

    • A、The routing table is populated by the forwarding table.
    • B、Devices running the Junos OS can accommodate multiple routing tables.
    • C、Information learned from routing protocols is stored in the routing table.
    • D、The primary routing table for IPv4 unicast routes is inet.4.

    正确答案:B,C

  • 第14题：

    Which two statements are true about the forwarding table?（）

    • A、The forwarding table lists each source protocol and preference for each destination
    • B、The forwarding table constains only active routes
    • C、The forwarding table is used to process transit packets
    • D、The forwarding table is stored in compact flash

    正确答案:B,C

  • 第15题：

    Which two statements are true regarding the USING and ON clauses in table joins?（）

    • A、Both USING and ON clauses can be used for equijoins and nonequijoins 
    • B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
    • C、The ON clause can be used to join tables on columns that have different names but compatible data types 
    • D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

    正确答案:C,D

  • 第16题：

    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

  • 第17题：

    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）  

    • A、 All the triggers are disabled.
    • B、 All the triggers are enabled by default.
    • C、 Enabled triggers remain enabled and disabled triggers remain disabled.
    • D、 Triggers are deleted when a Flashback Table operation is performed.

    正确答案:A

  • 第18题：

    单选题
    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）
    A

     An SCN is never used to perform a Flashback Table recovery.

    B

     If a significant number of changes have been made to the table， row movement must be enabled.

    C

     The tablespace must be offline before performing a Flashback Table recovery.

    D

     Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.


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

  • 第19题：

    多选题
    Which two statements are true regarding the USING clause in table joins?（）
    A

    It can be used to join a maximum of three tables

    B

    It can be used to restrict the number of columns used in a NATURAL join

    C

    It can be used to access data from tables through equijoins as well as nonequijoins

    D

    It can be used to join tables that have columns with the same name and compatible data types


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

  • 第20题：

    多选题
    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）
    A

    All the related indexes and views are automatically dropped

    B

    The flashback drop feature can recover only the table structure

    C

    Only the related indexes are dropped whereas views are invalidated

    D

    The flashback drop feature can recover both the table structure and its data


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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第23题：

    多选题
    Which three statements are true regarding the fine-grained auditing （FGA）？（）
    A

    FGA is possible on SELECT statements only.

    B

    The audit trail for FGA is stored in the FGA_LOG$ table.

    C

    The audit trail for FGA is stored in the AUD_LOG$ table.

    D

    FGA enables a SQL predicate to define when to audit an event.

    E

    FGA audits DELETE statements only when audit columns are specified.

    F

    FGA includes the SQL statement used by the user as part of the audit event entry.


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

  • 第24题：

    多选题
    Which two statements are true about the forwarding table?（）
    A

    The forwarding table lists each source protocol and preference for each destination

    B

    The forwarding table constains only active routes

    C

    The forwarding table is used to process transit packets

    D

    The forwarding table is stored in compact flash


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

相关内容