Question
a.
Access modes
b.
Access types
c.
Access time
d.
Access overhead
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. 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!
