Insertion of a large number of entries at a time into an index is referred to as __________ of the index.

Related MCQs

• A                                    index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
• While inserting the record into the index, if the search-key value does not appear in the index.
• A                      is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
• How many types of insertion anomalies:
• Which one of the following deletes all the entries but keeps the structure of the relation.
• In the above DDL command the foreign key entries are got by using the keyword
• 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.
• 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.