单选题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

题目
单选题
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.

相似考题

1.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.

2.While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column 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.

3. Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）A、It is ignored by the query optimizer.B、It is not used while the index is being rebuilt.C、The index cannot be rebuilt， and has to be re-created.D、The index is automatically rebuilt when used the next time

4.While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column 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.

更多“单选题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

    正确答案:A,D

  • 第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.

    正确答案:C,D

  • 第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.

    正确答案:A,B

  • 第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.

    正确答案:E

  • 第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.

    正确答案:A,D

  • 第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.

    正确答案:B

  • 第7题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    多选题
    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.


    正确答案： A,B
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column 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.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第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）

    正确答案:B,C,D,E

  • 第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.

    正确答案:B

  • 第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.

    正确答案:E

  • 第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.

    正确答案:B,F

  • 第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.

    正确答案:C

  • 第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.

    正确答案:A,E

  • 第19题：

    多选题
    Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）
    A

    It is ignored by the query optimizer.

    B

    It is not used while the index is being rebuilt.

    C

    The index cannot be rebuilt， and has to be re-created.

    D

    The index is automatically rebuilt when used the next time


    正确答案： B,C
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    多选题
    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.


    正确答案： D,A
    解析： 暂无解析

  • 第22题：

    多选题
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第23题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column 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.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    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


    正确答案： C,B
    解析： 暂无解析

相关内容