The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving <,≤,≥, or > is

Related MCQs

• 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.
• Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.
• The disk controller uses                  at each sector to ensure that the data is not corrupted on data retrieval.
• Which of the following option is use to retrieval of data?
• Retrieval of data is done by using a ____:
• 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                      index, an index entry appears for only some of the search-key values.
• In                                index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
• A                                    index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
• Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use                        on individual key values, allowing other key values to be inserted or deleted from the same leaf.