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

6 Maximum height of a B+ tree of order m with n key values is :
A log m(n)
B (m+n)/2
C logm/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]
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]


Month-wise Current Affairs 2021

Category-wise Current Affairs

Jobs by Qualification

Free Mock Test