Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

Get Attractive Job

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 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]

Chapters

Useful Computer Science EBooks