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!

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Hadoop

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

Internet of Things (IoT)

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

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

DBMS

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

Cyber Security

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

MongoDB

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

Object Oriented Programming Using C++

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