While inserting the record into the index, if the search-key value does not appear in the index.

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.
• 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.
•                          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.
• A                                    index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
• Insertion of a large number of entries at a time into an index is referred to as __________ of the index.
• How inserting data through stored procedure do reduces network traffic and increase database performance?
• Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.
• 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
• An                          consists of a search-key value and pointers to one or more records with that value as their search-key value.