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

Which statements are true regarding table compression？（）

题目
多选题
Which statements are true regarding table compression？（）
A

It saves disk space and reduces memory usage.

B

It saves disk space but has no effect on memory usage.

C

It incurs extra CPU overhead during DML as well as direct loading operations.

D

It incurs extra CPU overhead during DML but not direct loading operations.

E

It requires uncompress operation during I/O.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which statement about the enabling of table compression in Oracle Database 11g is true?()

A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.

B. Compression can be enabled only at the table level for both direct loads and conventional DML.

C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.

D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.


参考答案：D

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

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 statements are true regarding table compression？（）

  • A、 It saves disk space and reduces memory usage.
  • B、 It saves disk space but has no effect on memory usage.
  • C、 It incurs extra CPU overhead during DML as well as direct loading operations.
  • D、 It incurs extra CPU overhead during DML but not direct loading operations.
  • E、 It requires uncompress operation during I/O.

正确答案:A,C

第6题：

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

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

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

第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

更多相关问题
相关内容