违法和不良信息举报 联系客服
免费注册 登录

Which statements are true regarding system-partitioned table

题目
多选题
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
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第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题：

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

第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题：

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

第5题：

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

第6题：

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,D

第7题：

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

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容