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

Explore more Topics under UGC CBSE NET Exam

Q21.
Division operation is ideally suited to handle queries of the type :

a.

customers who have no account in any of the branches in Delhi

b.

customers who have an account at all branches in Delhi

c.

customers who have an account in at least one branch in Delhi

d.

customers who have only joint account in any one branch in Delhi

Discuss
Answer: (b).customers who have an account at all branches in Delhi
Q22.
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram?

a.

Generalization

b.

Aggregation

c.

Specialization

d.

Adding suitable attributes

Discuss
Answer: (d).Adding suitable attributes
Q23.
Which of the following is true?

I.  Implementation of self-join is possible in SQL with table alias.

II. Outer-join operation is basic operation in relational algebra.

III. Natural join and outer join operations are equivalent.

a.

I and II are correct

b.

II and III are correct

c.

Only III is correct

d.

Only I is correct

Discuss
Answer: (d).Only I is correct
Q24.
Which of the following is correct?

I. Two phase locking is an optimistic protocol.
II. Two phase locking is pessimistic protocol
III. Time stamping is an optimistic protocol.
IV. Time stamping is pessimistic protocol.

a.

I and III

b.

II and IV

c.

I and IV

d.

II and III

Discuss
Answer: (c).I and IV
Q25.
________________rules used to limit the volume of log information that has to be handled and processed in the event of system failure involving the loss of volatile information.

a.

Write-ahead log

b.

Check-pointing

c.

Log buffer

d.

Thomas

Discuss
Answer: (b).Check-pointing
Q26.
Let R = ABCDE is a relational scheme with functional dependency set F = {A -> B, B ->C,AC -> D}. The attribute closures of A and E are

a.

ABCD, Ø

b.

ABCD, E

c.

ɸ , Ø

d.

ABC, E

Discuss
Answer: (b).ABCD, E
Q27.
Consider the following statements:

I. Re-construction operation used in mixed fragmentation satisfies commutative rule.
II. Re-construction operation used in vertical fragmentation satisfies commutative rule
Which of the following is correct?

a.

I

b.

II

c.

Both are correct

d.

None of the statements are correct

Discuss
Answer: (b).II
Q28.
Which of the following is false?

a.

Every binary relation is never be in BCNF

b.

Every BCNF relation is in 3NF

c.

1 NF,2 NF, 3 NF and BCNF are based on functional dependencies

d.

Multivalued Dependency (MVD) is a special case of Join Dependency (JD)

Discuss
Answer: (c).1 NF,2 NF, 3 NF and BCNF are based on functional dependencies
Q29.
An Assertion is a predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is :

a.

CREATE ASSERTION',ASSERTION Name', CHECK',Predicate',

b.

CREATE ASSERTION 'ASSERTION NAME'

c.

CREATE ASSERTION, CHECK Predicate

d.

SELECT ASSERTION

Discuss
Answer: (a).CREATE ASSERTION',ASSERTION Name', CHECK',Predicate',
Q30.
Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock ?

(a) 2-phase Locking
(b) Time stamp - ordering

a.

Both (a) and (b)

b.

(a) only

c.

(b) only

d.

Neither (a) nor (b)

Discuss
Answer: (c).(b) only
Page 3 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!

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Internet of Things (IoT)

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

Operating System

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

Compiler Design

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

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Object Oriented Programming Using C++

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

Systems Analysis and Design Methods

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

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Human Computer Interaction

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