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 18 of 23

Explore more Topics under UGC CBSE NET Exam

Q171.
A sub class having more than one super class is called:

a.

Category

b.

Classification

c.

Combination

d.

Partial Participation

Discuss
Answer: (a).Category
Q172.
A relation R={A,B,C,D,E,F} is given with following set of functional dependencies:

F={A→B,AD→C,B→F,A→E}.

Which of the following is Candidate Key?

a.

A

b.

AC

c.

AD

d.

None of these

Discuss
Answer: (c).AD
Q173.
Which statement is false regarding data independence?

a.

Hierarchical data model suffers from data Independence

b.

Network model suffers from data Independence

c.

Relational model suffers only from logical data Independence

d.

Relational model suffers only from physical data Independence

Discuss
Answer: (c).Relational model suffers only from logical data Independence
Q174.
In DBMS, deferred update means:

a.

All the updates are done first but the entries are made in the log file later

b.

All the log files entries are made first but the actual updates are done later

c.

Every update is done first followed by a writing on the log file

d.

Changes in the views are deferred till a query asks for a view

Discuss
Answer: (b).All the log files entries are made first but the actual updates are done later
Q175.
Which statement is false regarding data independence ?

a.

Hierarchical data model suffers from data independence

b.

Network model suffers from data independence

c.

Relational model suffers only from logical data independence

d.

Relational model suffers only from physical data independence

Discuss
Answer: (c).Relational model suffers only from logical data independence
Q176.
Two phase protocol in a database management system is:

a.

a concurrency mechanism that is not deadlock free

b.

a recovery protocol used for restoring a database after a crash

c.

Any update to the system log done in 2-phases

d.

not effective in Database

Discuss
Answer: (a).a concurrency mechanism that is not deadlock free
Q177.
A relation R = {A, B, C, D, E, F} is given with following set of functional dependencies:

F = {A→B, AD→C, B→F, A→E}

Which of the following is candidate key ?

a.

A

b.

AC

c.

AD

d.

None of these

Discuss
Answer: (c).AD
Q178.
Immediate updates as a recovery protocol is preferable, when:

a.

Database reads more than writes

b.

Writes are more than reads

c.

It does not matter as it is good in both the situations

d.

There are only writes

Discuss
Answer: (b).Writes are more than reads
Q179.
Which of the following statement is wrong ?

a.

2-phase locking protocol suffers from deadlocks

b.

Time-Stamp protocol suffers from more abort

c.

Time stamp protocol suffers from cascading rollbacks where as 2-phase locking protocol do not

d.

None of these

Discuss
Answer: (c).Time stamp protocol suffers from cascading rollbacks where as 2-phase locking protocol do not
Q180.
A subclass having more than one super class is called .................

a.

Category

b.

Classification

c.

Combination

d.

Partial Participation

Discuss
Answer: (a).Category
Page 18 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!

Compiler Design

Unravel the process of translating source code into executable programs with our...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

DBMS

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

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...