Printed Page: 1 of 2

Subject Code: KCS501

0Roll No: 0 0 0 0 0 0 0 0 0 0 0 0 0

BTECH
(SEM V) THEORY EXAMINATION 2023-24
DATA BASE MANAGEMENT SYSTEM
TIME: 3 HRS M.MARKS: 100

Note: 1. Attempt all Sections. If require any missing data; then choose suitably.
SECTION A
1. Attempt all questions in brief. 2 x 10 = 20
Q No. Question Marks CO

a. What is the concept of keys in database? 2 1

b. What is strong & weak entity set? 2 1

c. Explain referential integrity. 2 2

d. Explain entity integrity constraints. 2 2

e. Write different inference rule for functional dependency? 2 3

f. Why do we normalize database? 2 3

g. What do you mean by testing of serializability? 2 4

90

1
h. Define replication in distributed database. 2 4

13
_2

i. Define concurrency control. 2 5

2.
P1

24
j. Define exclusive lock. 2 5
4D

5.
SECTION B
2. Attempt any three of the following:
.5
P2

17
a. Discuss three level of abstractions or schemas architecture of DBMS. 10 1
Q

|1

b. What is Aggregate function in SQL? Write SQL query for aggregate function. 10 2
4

c. Describe the following terms: (i) Multivalued dependency (ii) Trigger 10 3

1
4:

d. Discuss the procedure of deadlock detection and recovery in transaction? 10 4

:2
13

e. Write the salient features of graph based locking protocol with suitable example. 10 5
SECTION C
4

3. Attempt any one part of the following:

02

a. State the procedural DML and nonprocedural DML with their differences. 10 1
-2
01

b. Discuss the role of database administrator & explain the database architecture. 10 1
4. Attempt any one part of the following:
9-
|1

What is ER Diagram? Explain different components of an ER Diagram with employee

a. 10 2
project Management system.

Write difference between cross join, Natural join, left outer join and right outer join with
b. 10 2
suitable example.
5. Attempt any one part of the following:
What is functional dependency? Explain the procedure of calculating the canonical cover of
a. 10 3
a given functional dependency set with suitable example.

1|Page
QP24DP1_290 | 19-01-2024 13:24:14 | 117.55.242.131
 Printed Page: 2 of 2
Subject Code: KCS501
0Roll No: 0 0 0 0 0 0 0 0 0 0 0 0 0

BTECH
(SEM V) THEORY EXAMINATION 2023-24
DATA BASE MANAGEMENT SYSTEM
TIME: 3 HRS M.MARKS: 100

Describe the term MVD in the context of DBMS by giving an example. Discuss 4NF and
b. 10 3
5NF also.
6. Attempt any one part of the following:
What is conflict serializable Schedule? Explain the difference between conflict and view
a. 10 4
serializable schedule using suitable example?

What is Log? How is it maintained? Discuss the features of deferred database modification
b. 10 4
and immediate database modification in brief.
7. Attempt any one part of the following:
Discuss 2 phase commit (2PC) protocol and time stamp-based protocol with suitable
a. 10 5
example. How the validation-based protocols differ from 2PC?

What are multi version schemes of concurrency control? Describe with the help of an
b. 10 5
example. Discuss the various Time stamping protocols for concurrency control also.
90

1
13
_2

2.
P1

24
4D

5.
.5
P2

17
Q

|1
1 4
4:
:2
13
4
02
-2
01
9-
|1

2|Page
QP24DP1_290 | 19-01-2024 13:24:14 | 117.55.242.131