Checking It

1:A Reverse-Key index is useful for what following situation:

  1. The index key value is based on an Oracle Sequence.

  2. The typical access will be via a range of values.

  3. The index key value is always something unique.

2:When might Oracle NOT use a Reverse-Key index?

  1. The WHERE clause is using a < predicate.

  2. The WHERE clause is using a > predicate.

  3. The WHERE clause is using a BETWEEN function.

  4. All of the above

3:A Unique Index is the fastest way to access an individual row in a table.

True/False

4:What is the IOT overflow tablespace used for?

  1. To store additional indexed rows for the IOT

  2. To store statistics about the IOT

  3. To store additional IOT columns

  4. All of the above

5:A bitmap index is good for large, dynamic tables.

True/False

6:What is the purpose of a function-based index?

  1. To provide indexing on columns with any mathematical function

  2. To provide indexing on columns with any Oracle function

  3. To provide indexing on columns with specific functions

7:Bitmap Join Indexes are useful

  1. In about any join situation

  2. Where the primary table has a primary key constraint

  3. Where the primary table has a primary key constraint and the joining table(s) have unique key constraints

  4. Where the joining table(s) have primary or unique key constraints

8:In a Bitmap Join Index, what exactly is getting indexed?

  1. The primary table's column

  2. The join table(s) column

  3. Both the primary table and the join table column

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.190.156.93