Question
a.
Index entry
b.
Index hash
c.
Index cluster
d.
Index map
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
Similar Questions
Discover Related MCQs
Q. 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.
View solution
Q. In a __________ index, an index entry appears for only some of the search-key values.
View solution
Q. Incase the indices values are larger, index is created for these values of index. This is called
View solution
Q. A search key containing more than one attribute is referred to as a _________ search key.
View solution
Q. In B+ tree the node which points to another node is called
View solution
Q. Insertion of a large number of entries at a time into an index is referred to as __________ of the index.
View solution
Q. While inserting the record into the index, if the search-key value does not appear in the index.
View solution
Q. 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.
View solution
Q. A hash table can store a maximum of 10 records, currently there are records in location 1, 3,4,7,8,9,10. The probability of a new record going into location 2, with hash functions resolving collisions by linear probing is
View solution
Q. Key value pairs is usually seen in
View solution
Q. What is the best definition of a collision in a hash table?
View solution
Q. Which of the following scenarios leads to linear running time for a random search hit in a linear-probing hash table?
View solution
Q. Breadth First Search is used in
View solution
Q. What is the main limitation of Hierarchical Databases?
View solution
Q. The property (or set of properties) that uniquely defines each row in a table is called the:
View solution
Q. The separation of the data definition from the program is known as:
View solution
Q. In the client / server model, the database:
View solution
Q. The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?
View solution
Q. The database design that consists of multiple tables that are linked together through matching data stored in each table is called
View solution
Q. The association role defines:
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
Software Engineering
Learn about the systematic approach to developing software with our Software...
Java Programming
Level up your coding skills with our Java Programming MCQs. From object-oriented...