Incase the indices values are larger, index is created for these values of the index. This is called

Related MCQs

• Indices whose search key specifies an order different from the sequential order of the file are called                        indices.
• Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
• Bitmaps can be combined with regular B+- tree indices for relations where a few attribute values are extremely common, and other values also occur, but much less frequently.
• 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 ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• In a                      index, an index entry appears for only some of the search-key values.
• In a __________ index, an index entry appears for only some of the search-key values.
• A data dictionary is created when a __________ created.
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):