JOIN ADRE 2.0 Telegram Group

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]
Advertisement
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 Start Test

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

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]

ADRE 2.0 MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

Advertisement