Relational database management systems mcq quiz with answers 23

MCQ on various aspects in DBMS including time required to read disk block pages, block access per second,  primary dense index, secondary, b+ tree index, RDBMS Multiple Choice Questions with Answers

Database management systems - MCQ exam questions

1. You have a table with 1 million records. Each record fits exactly in one disk block in the hard disk, and the blocks for the table are sequential. The hard disk drive has a 10ms seek latency to start a read operation, and after it starts, it can read 10,000 blocks per second. How much time will you spend to read the entire table?

a) 10.01 seconds

b) 51.01 seconds

c) 100.01 seconds

d) 25.01 seconds

Answer: (c) 100.01 seconds Since the data stored in sequential (contiguous) order, in one seek we can read all data. Hence, the time required to read the entire table can be calculated as follows; Seektime + time to read all the disk blocks = 10ms + (1000000 blocks / 10000 blocks per sec)                                                                                     = 0.01 + 100 = 100.01 seconds.

 

2. Which of the following statements is wrong / irrelevant?

a) First and second level of secondary index are dense

b) Primary index can be dense

c) Primary index can be sparse

d) Secondary indices are always dense

Answer: (a) First and second level of secondary index are dense Multiple levels of indices are used to improve the accessibility in case if the index itself is very large. But a dense index includes all the search key values. Hence, building a dense index in second level on top of first level dense index is redundant.

 

3. The maximum number of levels between the root node and a leaf node in a B+ tree is called as

a) Degree of a tree

b) Order of a tree

c) Depth of a tree

d) None of the above

Answer: (c) Depth of a tree The depth of a tree is the maximum number of levels between the root node and a leaf node in the tree. The maximum number of children allowed per parent is referred as Degree or Order of a tree.

 

************************

Related posts:

• Go to Multiple Choice Questions in DBMS home

• Go to Normalization - MCQs page

• Go to General Mixed Quiz in all topics of DBMS page

• Go to Advanced DBMS Concepts page

Quiz questions with answers on DBMS concepts

calculate the time required to access the table from hard disk drive

How much time required to access a table from disk block pages for sequentially stored records

What is degree of a tree?

What is depth of a B+ tree?

What is order of a tree?