GkSeries.com

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

Download PDF

Database management system multiple choice questions and answers page contain 5 questions from chapter Relational DBMS. Each objective question has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(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)

Comment

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

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(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

Comment

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

Comment

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

Comment

Answer: Option [D]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test