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!

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Compiler Design

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

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

R Programming

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

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

Object Oriented Programming

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

Java Spring Framework

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

Visual Basic

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