In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.

Related MCQs

• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• An                          consists of a search-key value and pointers to one or more records with that value as their search-key value.
• An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
• In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
• The        algorithm scans each index for pointers to tuples that satisfy an individual condition.
• If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by
• A special redo-only log record < Ti, Xj, V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called
• While inserting the record into the index, if the search-key value does not appear in the index.
•                          using a log record sets the data item specified in the log record to the old value.
• In                                index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.