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

Explore more Topics under UGC CBSE NET Exam

Q131.
The SQL Expression

Select distinct T. branch name from branch T, branch S where T. assets > S. assets and S. branch-city = DELHI,

finds the name of

a.

all branches that have greater asset than any branch located in DELHI.

b.

all branches that have greater assets than allocated in DELHI.

c.

the branch that has the greatest asset in DELHI.

d.

any branch that has greater asset than any branch located in DELHI.

Discuss
Answer: (a).all branches that have greater asset than any branch located in DELHI.
Q132.
Which of the following is the recovery management technique in DDBMS ?

a.

2PC (Two Phase Commit)

b.

Backup

c.

Immediate update

d.

All of the above

Discuss
Answer: (d).All of the above
Q133.
Which of the following is the process by which a user’s privileges ascertained ?

a.

Authorization

b.

Authentication

c.

Access Control

d.

None of these

Discuss
Answer: (a).Authorization
Q134.
The basic variants of time-stampbased method of concurrency control are

a.

Total time stamp-ordering

b.

Partial time stamp ordering

c.

Multiversion Time stamp ordering

d.

All of the above

Discuss
Answer: (d).All of the above
Q135.
A transaction can include following basic database access operations :

a.

Read_item(X)

b.

Write_item(X)

c.

Both (A) and (B)

d.

None of these

Discuss
Answer: (c).Both (A) and (B)
Q136.
Consider a hash table of size m = 10000 and the hash function h(k) = ∟m(kA mod 1)'┘ for A = (√5–1)/2. The location to the key k = 123456 is

a.

46

b.

47

c.

41

d.

43

Discuss
Answer: (c).41
Q137.
The dependency preservation decomposition is a property to decompose database schema D, in which each functional dependency X->Y specified in F,

a.

appeared directly in one of the relation schemas Ri in the decomposed D.

b.

could be inferred from dependencies that appear in some Ri.

c.

both a and b

d.

None of these

Discuss
Answer: (c).both a and b
Q138.
Which of the following is an optimistic concurrency control method?

a.

Validation based

b.

Time stamp ordering

c.

Lock-based

d.

None of these

Discuss
Answer: (a).Validation based
Q139.
Which of the following is the process by which a user’s access to physical data in the application is limited, based on his privileges?

a.

Authorization

b.

Authentication

c.

Access Control

d.

All of these

Discuss
Answer: (c).Access Control
Q140.
Linear probing suffers from a problem known as

a.

Secondary clustering

b.

Primary clustering

c.

Both a and b

d.

None of these

Discuss
Answer: (b).Primary clustering
Page 14 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!

Cryptography and Network Security

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

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Visual Basic

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

Computer Graphics

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

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Software Engineering

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

Python

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

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...