[多选]
On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?（）

A . Only the ORD_CUSTOMER_IX1 index created.
B . Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
C . Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
D . The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
E . Both the indexes are created and used by the optimizer for queries on the ORDERS table.
F . Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

在电渣压力焊接施工时，焊剂受潮，焊接过程中产生大量气体渗入熔池；钢筋锈蚀严重或表面不清洁，易导致（）。气孔。焊包不均。偏心。咬边。施工组织设计按编制阶段不同可分为（） A.初步施工组织设计。 B.施工组织总设计。 C.单位工程施工组织设计。 D.实施性施工组织设计。预期原则 2级关断是属于（）引起的关断生产之工艺系统。火灾。主电源失电。 Which two statements are true when row archival management is enabled?（） The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.。 The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.。 The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.。 The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.。 The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.。

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-060题库

相关题目: