单选题A bitmap join index is defined as（）.A An index used to join two bitmap indexes on a table.B A bitmap index created for the join of two or more tables.C A bitmap index created on the join of two or more indexes.D A bitmap index created on the join of tw

第1题：

Which two statements are true regarding B-tree indexs（）

• A、The leaf blocks in the index are doubly linked.
• B、The leaf node stores a bitmap for each key value.
• C、The rows with NULL value in key columns also have entries in the index.
• D、The deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry

第2题：

Which two statements are true about a bitmap index？ （）

• A、It is recommended for the columns that have unique values.
• B、It can be converted to a B-tree index by using the ALTER INDEX command.
• C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
• D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

第3题：

Which two statements about views are true?（）

• A、A view can be created as read only.
• B、A view can be created as a join on two or more tables.
• C、A view cannot have an ORDER BY clause in the SELECT statement.
• D、A view cannot be created with a GROUP BY clause in the SELECT statement.
• E、A view must have aliases defined for the column names in the SELECT statement.

第4题：

You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

• A、 The index tablespace contains bitmap indexes.
• B、 The index tablespace contains more than one data file.
• C、 The index tablespace supports only complete recovery.
• D、 The index tablespace is not a dictionary-managed tablespace.
• E、 There is a dependency relationship between a table and its indexes.

第5题：

Which two statements are true regarding B-tree index（）

• A、The leaf blocks in the index are doubly linked.
• B、The leaf node stores a bitmap for each key value.
• C、The rows with NULL value in key columns also have entries in the index.
• D、The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.

第6题：

A bitmap join index is defined as（）.

• A、An index used to join two bitmap indexes on a table.
• B、A bitmap index created for the join of two or more tables.
• C、A bitmap index created on the join of two or more indexes.
• D、A bitmap index created on the join of two or more indexed-organized tables.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Online index rebuild functionality has been extended to include which four index structures？（）

• A、Bitmap indexes.
• B、Reverse key indexes.
• C、Function-based indexes.
• D、Key-compressed indexes on regular tables.
• E、Key-compressed indexes on IOT （including secondary indexes）

第14题：

While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

• A、 A primary key must have been created.
• B、 A mapping table must have been created.
• C、 An overflow tablespace must have been specified.
• D、 The PCTTHRESHOLD option must have been specified.

第15题：

You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）

• A、The index tablespace contains bitmap indexes.
• B、The index tablespace contains more than one data file.
• C、The index tablespace supports only complete recovery.
• D、The index tablespace is not a dictionary­managed tablespace.
• E、There is a dependency relationship between a table and its indexes.

第16题：

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.

第17题：

Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）

• A、The DML operations re-create the Bitmap index blocks.
• B、The Bitmap index is rebuilt automatically after a DML operation.
• C、The smallest amount of a bitmap that can be locked is a bitmap segment.
• D、Additional time is taken to remove NULL values from the Bitmap index after a DML operation.

第18题：

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?（）

• A、Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B、The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• C、Only the ORD_CUSTOMER_IX1 index is created.
• D、Only the ORD_CUSTOMER_IX2 index is created.
• E、Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：