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)

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

Article and Schedule Quiz Start Test!
(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]

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!

Chapters