adplus-dvertising

Welcome to the DBMS MCQs Page

Dive deep into the fascinating world of DBMS with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of DBMS, a crucial aspect of UGC CBSE NET Exam. In this section, you will encounter a diverse range of MCQs that cover various aspects of DBMS, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within UGC CBSE NET Exam.

frame-decoration

Check out the MCQs below to embark on an enriching journey through DBMS. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of UGC CBSE NET Exam.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of DBMS. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

DBMS MCQs | Page 13 of 23

Explore more Topics under UGC CBSE NET Exam

Q121.
B+ tree are preferred to binary tree in Database because

a.

Disk capacity are greater than memory capacities

b.

Disk access is much slower than memory access

c.

Disk data transfer rates are much less than memory data transfer rate

d.

Disks are more reliable than memory

Discuss
Answer: (b).Disk access is much slower than memory access
Q122.
A Transaction Manager is which of the following ?

a.

Maintains a log of transactions

b.

Maintains before and after database images

c.

Maintains appropriate concurrency control

d.

All of the above

Discuss
Answer: (d).All of the above
Q123.
A B+ tree index is to be built on the name attribute of the relation STUDENT. Assume that all students names are of length 8 bytes, disk block are of size 512 bytes and index pointers are of size 4 bytes. Given this scenario what would be the best choice of the degree (i.e. the number of pointers per node) of the B+ tree ?

a.

16

b.

42

c.

43

d.

44

Discuss
Answer: (a).16
Q124.
What is Granularity ?

a.

The size of database

b.

The size of data item

c.

The size of record

d.

The size of file

Discuss
Answer: (b).The size of data item
Q125.
Which level of Abstraction describes what data are stored in the Database ?

a.

Physical level

b.

View level

c.

Abstraction level

d.

Logical level

Discuss
Answer: (d).Logical level
Q126.
The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is …………….

a.

Temporary Select Problem

b.

Temporary Modify Problem

c.

Dirty Read Problem

d.

None of the above

Discuss
Answer: (c).Dirty Read Problem
Q127.
Consider a schema R(A, B, C, D) and functional dependencies A->B and C->D. Then the decomposition R1(A, B) and R2(C, D) is

a.

Dependency preserving but not lossless join

b.

Dependency preserving and lossless join

c.

Lossless Join but not dependency preserving

d.

Lossless Join

Discuss
Answer: (a).Dependency preserving but not lossless join
Q128.
A hash table has space for 75 records, then the probability of collision before the table is 6% full.

a.

.25

b.

.20

c.

.35

d.

.30

Discuss
Answer: (b)..20
Q129.
Which command classes text file, which has been created using “SET ALTERNATIVE” < FILE NAME > “Command” ?

a.

SET ALTERNATE OFF

b.

CLOSE DATABASE

c.

CLOSE ALTERNATE

d.

CLEAR ALL

Discuss
Answer: (a).SET ALTERNATE OFF
Q130.
Which of the following statements is true, when structure of database file with 20 records is modified?

a.

? EOF ( ) Prints T

b.

? BOF ( ) Prints F

c.

? BOF ( ) Prints T

d.

? EOF ( ) Prints F

Discuss
Answer: (a).? EOF ( ) Prints T
Page 13 of 23

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...