o m

r .c
pe m
p a c o
r r .
b pe
pa
b r
 o m
r .c
pe m
p a c o
r r .
b pe
pa
b r
Roll No. Total No. of Pages : 02
Total No. of Questions : 18
[Link]. (CSE) (Sem.–5)
DATABASE MANAGEMENT SYSTEMS
Subject Code : BTCS-501-18
[Link] : 91016
Date of Examination : 15-12-22
Time : 3 Hrs. Max. Marks : 60

INSTRUCTIONS TO CANDIDATES :
1. SECTION-A is COMPULSORY consisting of TEN questions carrying T WO marks
each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students
have to attempt any FOUR questions.
3. SECTION-C contains T HREE questions carrying T EN marks each and students
have to attempt any T WO questions.

SECTION-A

o m
Write briefly :
.r c
e
1. Define candidate key and give an example.
p m
a o
.r c
2. List various responsibilities performed by database management system.

r p
b e
3. Explain the syntax of create table command with the help of an example.

p
4. What is transitive dependency?

p a
relation?
b r
5. How can we compute candidate key from a given set of functional dependencies in a

6. Differentiate between specialization and generalization.

7. Differentiate between inner join and outer join.

8. Explain transition of "states of a transaction.

9. Differentiate between authentication and authorization

10. Explain DAC.

1 | M-91016 (S2)-1786
 SECTION-B

11. Differentiate between traditional file system and database management system.

12. Illustrate various operations of relational algebra with the help of an example each.

13. Discuss lock-based concurrency control. How can it lead to deadlock?

14. Discuss role of B Tree in storage management.

15. Explain ER Diagram with the help of an example.

SECTION-C

16. What is normalization? Explain different types of normalizations with the help of an
example.

17. Explain in detail log-based recovery. Explain the recovery algorithm using redo and undo
phase.
o m
18. Write short note on:
.r c
a. Web databases.

p e m
a
b. Distributed databases
o
r p .r c
b p e
p a
b r

2 | M-91016 (S2)-1786
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
[Link]. CSE (Internet of Things and Cyber Security including Block
Chain Technology) (Sem.–5)
DATABASE MANAGEMENT SYSTEMS
Subject Code : BTCS-501-18
[Link] : 92359
Date of Examination : 15-12-22
Time : 3 Hrs. Max. Marks : 60

INSTRUCTIONS TO CANDIDATES :
1. SECTION-A is COMPULSORY consisting of TEN questions carrying T WO marks
each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students
have to attempt any FOUR questions.
3. SECTION-C contains T HREE questions carrying T EN marks each and students
have to attempt any T WO questions.

o m
SECTION-A

1. Write briefly : .r c
p e
a) Need of various data models
m
a o
r p
b) Features of ER model
.r c
b
c) Limitations of MYSQL
p e
d) Usage of open source DBMS
p a
e) Examples of query optimization
b r
f) Significance of hashing

g) Advantages of B-Trees

h) Role of Indices

i) Characteristics of Oracle

j) Name the concurrency control schemes.

1 | M-92359 (S2)-500
 SECTION-B

2. How ER model is different from Network model?

3. Explain any three DDL commands used in SQL.

4. How does the evaluation of relational algebra expressions is done?

5. Differentiate between Ordered indexing and Hashing.

6. Discuss the ACID property in detail.

SECTION-C

7. Discuss the major purposes of SQL query optimization in detail. Also define the metrics
for analyzing query performance for SQL query optimization.

8. Define integrity constraints. Explain the various types of integrity constraints.

9.
o m
How does the serializable schedule preserves the order of the operation in each of the

.r c
individual transaction?

p e m
a o
r p .r c
b p e
p a
b r

2 | M-92359 (S2)-500
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
[Link]. (CSE) (Sem.–5)
DATABASE MANAGEMENT SYSTEM
Subject Code : BTCS-501-18
[Link] : 78320
Date of Examination : 15-12-22
Time : 3 Hrs. Max. Marks : 60

INSTRUCTIONS TO CANDIDATES :
1. SECTION-A is COMPULSORY consisting of TEN questions carrying T WO marks
each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students
have to attempt any FOUR questions.
3. SECTION-C contains T HREE questions carrying T EN marks each and students
have to attempt any T WO questions.

SECTION-A

1. Write briefly :
o m
a) Define DBMS .r c
p e m
b) What is a view level?
a o
c) State 1 NF.
r p .r c
b
d) What is meaning of functional dependence?
p e
e) Difference between alter and update?
p a
f) What is entity integrity Constraint?
br
g) Define view serializability.

h) Define deadlock in transactions.

i) What is access control?

j) What is database recovery?

1 | M-78320 (S2)-484
 SECTION-B

2. What is the need of DBMS and discuss in detail the different DBMS Models.

3. Define Normalization. Explain 3NF and BCNF with the help of a suitable example.

4. What is the concept of locking techniques? Discuss the Two-phase locking protocol.

5. Explain the concept of ACID properties with the help of suitable example.

6. Explain the concept of authorization and authentication

SECTION-C

7. What are different data models used in DBMS? Discuss in detail about the ER Model
used in the RDBMS.

8. Explain different types of Joins used in RDBMS with the help of example and why do we
use self-join?
o m
9. Write a short note on :
.r c
p e
a) Object Relational Databases
m
b) Query Optimization
a o
r p .r c
b p e
p a
b r

2 | M-78320 (S2)-484
 o m
r .c
pe m
p a c o
r r .
b pe
pa
b r
 o m
r .c
pe m
p a c o
r r .
b pe
pa
b r
 o m
r .c
pe m
p a c o
r r .
b pe
pa
b r
 o m
r .c
pe m
p a c o
r r .
b pe
pa
b r