多选题

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）

ABoth the indexes are created; however, only the ORD_COSTOMER index is visible.

BThe optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

COnly the ORD_CUSTOMER_IX1 index is created.

DOnly the ORD_CUSTOMER_IX2 index is created.

EBoth the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

略

相似试题

Which statement is FALSE regarding WebLogic Server 12c?（）
单选题查看答案
Which two IDEs are supported development environments for WebLogic Server 12c in version 12.1.1?（）
多选题查看答案
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）
单选题查看答案
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12? （）
单选题查看答案
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
单选题查看答案
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
单选题查看答案
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
单选题查看答案
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
单选题查看答案
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
单选题查看答案
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
多选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证