To identify the deleted records we use the

Related MCQs

• 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.
• ARIES uses a                        to identify log records, and stores it in database pages.
• How can the values in the relation teaches be deleted?
• In order to reduce the overhead in retrieving the records from the storage space we use
• A unit of storage that can store one or more records in a hash file organization is denoted as
• The file organization which allows us to read records that would satisfy the join condition by using one block read is
• An                          consists of a search-key value and pointers to one or more records with that value as their search-key value.
• 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                          the system scans each file block and tests all records to see whether they satisfy the selection condition.
• 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