Question
a.
Access modes
b.
Access types
c.
Access time
d.
Access overhead
Posted under Indexing and Hashing DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The types of access that are supported efficiently are called as ________
Similar Questions
Discover Related MCQs
Q. The time it takes to find a particular data item is called as ___________
View solution
Q. The time it takes to insert a new data item is called ____________
View solution
Q. The time it takes to delete a data item is called as _________
View solution
Q. The additional space occupied by an index structure is called as _________
View solution
Q. If the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
View solution
Q. State true or false: Clustering indices are also called as primary indices
View solution
Q. If an index entry appears for every search key value in the file, it is called as ________
View solution
Q. If an index entry appears for only some of the search key values in the file, it is called as ________
View solution
Q. Indices with two or more levels are called as?
View solution
Q. A search key containing more than one attribute is called a _________ search key
View solution
Q. State true or false: B+ trees are not always balanced trees.
View solution
Q. What are the leaf nodes in a B+ tree?
View solution
Q. Non-leaf nodes are also called as __________
View solution
Q. The queries used to find all records with search key values in a particular range are known as ________
View solution
Q. Statement 1: Insertion of record might require the change in position of the initial nodes.
Statement 2: Deletion of records might require the change in position of the initial nodes.
View solution
Q. If a relation can have more than one record containing the same search key value, the search key is said to be a __________
View solution
Q. State true or false: The fanout of nodes can be increased by using a technique 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. ___________ are the indices that store the values of some attributes along with the pointers to the record.
View solution
Q. The term ______ is used to denote a unit of storage that can store one or more records
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...
Microprocessor
Understand the heart of your computer with our Microprocessor MCQs. Topics include...
