The strategy can retrieve a single record if the equality condition is on a key; multiple records may be retrieved if the indexing field is not a key is

Related MCQs

• Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.
• 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.
• 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.
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• Which of the following clause specifies the table or tables from where the data has to be retrieved?
• 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.
• With multiple disks, we can improve the transfer rate as well by                        data across multiple disks.
• 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
•                          using a log record sets the data item specified in the log record to the old value.