What should be done to use a function-based index?

1.	What should be done to use a function-based index?
A.	The table must be analyzed after the index is created
B.	The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes
C.	Both A & B
D.	None of the above
Answer» B. The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes

Discussion

No Comment Found

Related MCQs

What should be done to use a function-based index?
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:a) High availability of datab) Faster primary key access to the table datac) Compact storage for the tableWhich type of tables would you use to achieve these objectives?
Which of the following condition is true to create an index in your own schema?
In ALTER TABLE Mainte ce Operations for Table Partitions which mainte ce operation partition is used by range, hash, list, composite(range/hash), composite(range/list) from the following?
In the following example which method is used to partition the index-organized table, sales?CREATE TABLE sales(acct_no NUMBER(5),acct_name CHAR(30),amount_of_sale NUMBER(6),week_no INTEGER,sale_details VARCHAR2(1000),PRIMARY KEY (acct_no, acct_name, week_no))ORGANIZATION INDEXINCLUDING week_noOVERFLOWPARTITION BY HASH (week_no)PARTITIONS 16STORE IN (ts1, ts2, ts3, ts4)OVERFLOW STORE IN (ts3, ts6, ts9);
What benefits does creating an index with NOLOGGING have?
Which key have automatically indexes, but you might want to create an index on a foreign key?
What Enables you to quickly change storage and tablespace parameters without having to drop the original index?
Which partition forms of composite partitioning is well suited for historical data, but lets you further group the rows of data based on unordered or unrelated column values?
Which type of partition will be done for the following?1. Partition description identifying partition bounds.

What should be done to use a function-based index?

Discussion

No Comment Found

Related MCQs

Reply to Comment