Which of the following index can occur only one per table?

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• 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                                    index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
• A table can be logically connected to another table by defining a
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• The                          scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
• Drop Table cannot be used to drop a table referenced by a …………… constraint.
• __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.