Which of the following index is made up of more than one column?

Related MCQs

• In                                index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
• Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            
• A                                    index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
• You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?
• 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.
• 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.
• 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.
• Incase the indices values are larger, index is created for these values of the index. This is called