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!

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Java Spring Framework

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

Web Technologies

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

Software Engineering

Learn about the systematic approach to developing software with our Software...

Microprocessor

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

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

DBMS

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

Digital Communication

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

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...