Relational DBMS Objective Type Questions and Answers | Database Management System Problems & Solutions

Questions

6 Maximum height of a B+ tree of order m with n key values is :

A log m(n)

B (m+n)/2

C log_m/2(m+n)

D log_(1/2m)(n+1/2)

Answer: Option [D]

7 In a relational database a referential integrity constraint can be specified with the help of :

A primary key

B foreign key

C secondary key

D none of the above

Answer: Option [B]

⭐ Make GKSeries Your Preferred Source on Google

8 A host language is :

A Query Language

B Storage Definition Language

C DML embedded in the general purpose language

D None of the above

Answer: Option [C]

9 Multilevel Indexing :

A Uses a Binary Search

B Does away Binary Search

C Uses a Binary Tree Search

D None of the above

Answer: Option [C]

10 Anomalies imply additional work to be done for :

A Insertion into relation

B Modification of a relation

C Loss of information due to deletion

D All of the above

Answer: Option [D]