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 GATE CSE 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 GATE CSE 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 GATE CSE 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 9 of 11

Explore more Topics under GATE CSE Exam

Q81.
Suppose a database schedule S involves transactions T1, ....Tn. Construct the precedence graph of S with vertices representing the transactions and edges representing the conflicts. If S is serializable, which one of the following orderings of the vertices of the precedence graph is guaranteed to yield a serial schedule?

a.

Topological order

b.

Depth-first order

c.

Breadth-first order

d.

Ascending order of transaction indices

Discuss
Answer: (a).Topological order
Q82.
Consider the following database schedule with two transactions, T1 and T2.

S = r2(X); r1(X); r2(Y); w1(X); r1(Y); w2(X); a1; a2;

where ri(Z) denotes a read operation by transaction Ti on a variable Z, wi(Z) denotes a write operation by Ti on a variable Z and ai denotes an abort by transaction Ti . Which one of the following statements about the above schedule is TRUE?

a.

S is non-recoverable

b.

S is recoverable, but has a cascading abort

c.

S does not have a cascading abort

d.

S is strict

Discuss
Answer: (c).S does not have a cascading abort
Q83.
Consider the following three schedules of transactions T1, T2 and T3. [Notation: In the following NYO represents the action Y (R for read, W for write) performed by transac­tion N on object O.]

(S1) 2RA 2WA 3RC 2WB 3WA 3WC 1RA 1RB 1WA 1WB
(S2) 3RC 2RA 2WA 2WB 3WA 1RA 1RB 1WA 1WB 3WC
(S3) 2RA 3RC 3WA 2WA 2WB 3WC 1RA 1RB 1WA 1WB

Which of the following statements is TRUE?

a.

S1, S2 and S3 are all conflict equivalent to each other

b.

No two of S1, S2 and S3 are conflict equivalent to each other

c.

S2 is conflict equivalent to S3, but not to S1

d.

S1 is conflict equivalent to S2, but not to S3

Discuss
Answer: (d).S1 is conflict equivalent to S2, but not to S3
Q84.
Which of the following statement is/are incorrect?

A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.
B: Checkpoint in schedules are inserted to ensure recoverability.

a.

Only 1

b.

Only 2

c.

Both 1 and 2

d.

None

Discuss
Answer: (b).Only 2
Q85.
An index is clustered, if

a.

it is on a set of fields that form a candidate key

b.

it is on a set of fields that include the primary key

c.

the data records of the file are organized in the same order as the data entries of the index

d.

the data records of the file are organized not in the same order as the data entries of the index

Discuss
Answer: (c).the data records of the file are organized in the same order as the data entries of the index
Q86.
A clustering index is defined on the fields which are of type

a.

non-key and ordering

b.

non-key and non-ordering

c.

key and ordering

d.

key and non-ordering

Discuss
Answer: (a).non-key and ordering
Q87.
A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Then that index is called

a.

Dense

b.

Sparse

c.

Clustered

d.

Unclustered

Discuss
Answer: (c).Clustered
Q88.
Which of the following relational calculus expressions is not safe?

a.

a

b.

b

c.

c

d.

d

Discuss
Answer: (c).c
Q89.
Consider the following SQL query:

select distinct al, a2,........., an
from r1, r2,........, rm
where P

For an arbitrary predicate P, this query is equivalent to which of the following relational algebra expressions ?

a.

A

b.

B

c.

C

d.

D

Discuss
Answer: (a).A
Q90.
Consider three data items D1, D2 and D3 and the following execution schedule of transactions T1, T2 and T3. In the diagram, R(D) and W(D) denote the actions reading and writing the data item D respectively.

Which of the following statements is correct?

a.

The schedule is serializable as T2; T3; T1

b.

The schedule is serializable as T2; T1; T3

c.

The schedule is serializable as T3; T2; T1

d.

The schedule is not serializable

Discuss
Answer: (d).The schedule is not serializable
Page 9 of 11

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!

Internet of Things (IoT)

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

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Operating System

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

Embedded Systems

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

Object Oriented Programming

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

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...