网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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.” 相关考题
考题
在Oracle中,你需要创建索引提高薪水审查的性能,该审查要对员工薪水提高12个百分点后进行分析处理,下面哪个createindex命令能解决此问题()。
A.CREATE INDEX my_idx_1 ON employee（salary*1.12）B.CREATE UNIQUE INDEX my_idx_1 ON employee（salary）C.CREATE BITMAP INDEX my_idx_1 ON employee（salary）D.CREATE INDEX my_idx_1 ON employee（salary）REVERSE
考题
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.
考题
Overlay Transport Virtualization （OTV） join interface is used to source the OTV encapsulated traffic and send it to the Layer 3 domain of the data center network. Which statements are true about OTV join interface？ （）A、 Join interface is a Layer 3 entity， and with the Cisco NX-OS release 6.0， it can only be defined as a physical interface， physical subinterface， Layer 3 port channel， or Layer 3 port channel subinterface.B、 A single join interface can be defined and associated with a given OTV overlay.C、 Multiple overlays can also share the same join interface.D、 Join interface can be a loopback interface.E、 The join interface is a Layer 3 entity that can be defined as a physical interface but not as a logical one.
考题
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
考题
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）
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
单选题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.
考题
单选题在Oracle中，你需要创建索引提高薪水审查的性能，该审查要对员工薪水提高12个百分点后进行分析处理，下面哪个createindex命令能解决此问题（）。A
CREATE INDEX my_idx_1 ON employee（salary*1.12）B
CREATE UNIQUE INDEX my_idx_1 ON employee（salary）C
CREATE BITMAP INDEX my_idx_1 ON employee（salary）D
CREATE INDEX my_idx_1 ON employee（salary）REVERSE
考题
单选题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.
考题
多选题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.
考题
单选题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 dictionarymanaged tablespace.E
There is a dependency relationship between a table and its indexes.
考题
多选题Overlay Transport Virtualization （OTV） join interface is used to source the OTV encapsulated traffic and send it to the Layer 3 domain of the data center network. Which statements are true about OTV join interface？ （）AJoin interface is a Layer 3 entity， and with the Cisco NX-OS release 6.0， it can only be defined as a physical interface， physical subinterface， Layer 3 port channel， or Layer 3 port channel subinterface.BA single join interface can be defined and associated with a given OTV overlay.CMultiple overlays can also share the same join interface.DJoin interface can be a loopback interface.EThe join interface is a Layer 3 entity that can be defined as a physical interface but not as a logical one.
考题
多选题Which two statements are true about a bitmap index？ （）AIt is recommended for the columns that have unique values.BIt can be converted to a B-tree index by using the ALTER INDEX command.CIt 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.DUpdating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
考题
多选题Which two statements are true regarding B-tree index（）AThe leaf blocks in the index are doubly linked.BThe leaf node stores a bitmap for each key value.CThe rows with NULL value in key columns also have entries in the index.DThe 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.
考题
单选题You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）A
Rebuild the index.B
Coalesce the index.C
Drop and re-create the index in the new tablespace.D
Relocate the index using the ALTER INDEX...MOVE statement.
考题
单选题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.
考题
单选题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.
考题
多选题Which two statements are true regarding B-tree indexs（）AThe leaf blocks in the index are doubly linked.BThe leaf node stores a bitmap for each key value.CThe rows with NULL value in key columns also have entries in the index.DThe deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry
热门标签
最新试卷
