Question 56
Which index is created on a non-ordering field of a table?
Secondary indexes are built on non-ordering fields of a data file and require candidate keys or pointers to records.
Which index is created on a non-ordering field of a table?
Secondary indexes are built on non-ordering fields of a data file and require candidate keys or pointers to records.
What is an index called if an entry exists in the index file for EVERY search key value in the data file?
A Dense Index has an index entry for every single search key value (and record) present in the data file.
What is an index called if entries exist for only SOME of the search key values in the data file?
A Sparse Index contains index records for only a subset of data search keys (usually one entry per data block).
In the Wound-Wait deadlock prevention scheme, what happens when an older transaction requests a resource held by a younger transaction?
Wound-Wait is preemptive: an older transaction requesting a resource held by a younger transaction wounds (aborts) the younger transaction. If a younger transaction requests a resource held by an older one, the younger transaction waits.
In the Wait-Die deadlock prevention scheme, if an older transaction requests a resource held by a younger transaction, what happens?
In Wait-Die (non-preemptive), an older transaction is allowed to wait for a younger transaction; if a younger requests from an older, the younger 'dies' (aborts).