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
Article and Schedule Quiz 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 FULL LENGTH MOCK TEST

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

Advertisement