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!

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

MySQL Database

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

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...