Scribd
Upload
2K views3 pages

DBMS Sample Paper For 2025

This document is an examination question paper for the Database Management Systems course at BVC College of Engineering, covering various topics such as DBMS applications, data independence, relational algebra, and integrity constraints. It consists of two parts: Part-A with compulsory short answer questions and Part-B with detailed questions from different units. The exam is scheduled for April 2025, with a total duration of 3 hours and a maximum score of 70 marks.

Uploaded by

Surendranath Kalagara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2K views3 pages

DBMS Sample Paper For 2025

This document is an examination question paper for the Database Management Systems course at BVC College of Engineering, covering various topics such as DBMS applications, data independence, relational algebra, and integrity constraints. It consists of two parts: Part-A with compulsory short answer questions and Part-B with detailed questions from different units. The exam is scheduled for April 2025, with a total duration of 3 hours and a maximum score of 70 marks.

Uploaded by

Surendranath Kalagara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Course Code:23CS4T05

Reg: VR23

BVC COLLEGE OF ENGINEERING


(AUTONOMOUS)
II - B.Tech II-Semester Regular Examinations (VR23), APR - 2025
DATABASE MANAGEMENT SYSTEMS
(Common to CSE & AIML branches)
Time: 3 hours Max. Marks: 70
-------------------------------------------------------------------------------------------------------------------------------
Question Paper consists of Part-A and Part-B
All the questions in Part - A are compulsory.
Answer one question from each unit in Part-B
--------------------------------------------------------------------------------------------------------------------------------
PART–A (10 X 2 = 20M)
Marks CO BL
1. a) What are the applications of DBMS? (2M) CO1 L1
b) What is Super class?
(2M) CO1 L1
c) List out the operations of DML with syntax. (2M) CO2 L2
d) What is the difference between file system and database? (2M) CO2 L2
e) Define normalization. (2M) CO3 L3
f) Write the difference between views and joins. (2M) CO3 L3
g) What is BCNF? Explain. (2M) CO4 L4

h) What are integrity constraints? (2M) CO4 L4


i) What are the operations of B+ trees? (2M) CO5 L5
j) Define ACID properties (2M) CO5 L5

Page 1 of 3
PART–B (5 X 10 = 50M)
UNIT - I

Marks CO BL
2(a) Explain three tier schema architecture for data independence. 5(M) CO1 L4

(b) What is ER diagram? Explain with an example. 5(M) CO1 L3


(OR)
3(a) Analyze the centralized and client server architecture for the database. 5(M) CO1 L3

(b) Explain the following with suitable example. 5(M) CO1 L3


i) Inheritance
ii) Specialization
iii) generalization

UNIT - II

Marks CO BL

4(a) Create a student database and display the data using where clause. 5(M) CO2 L3

(b) What are null values? Explain the importance of null values. 5(M) CO2 L3
(OR)
5 Explain relational algebra and illustrate with suitable example. 10(M) CO2 L3

UNIT - III

Marks CO BL
6(a) Explain the creation of table with relationship. 5(M) CO3 L3

(b) Explain the implementation of integrity constraints. 5(M) CO3 L3


(OR)
7(a) Create an employee database and display EMP_NAME who is having 5(M) CO3 L3
maximum salary of 50000.

(b) Implement different types of Joins. 5(M) CO3 L4

UNIT - IV

Marks CO BL
8(a) What is Functional Dependency? Explain with suitable example. 5(M) CO4 L3

(b) Create a student database and verify is the database is in 3NF or not. 5(M) CO4 L3

Page 2 of 3
(OR)
Consider a relation R with attributes (student, subject, teacher)
9 10(M) CO4 L3
Student Teacher Subject

Jhansi P.Naresh Database

jhansi K.Das C

subbu P.Naresh Database

subbu R.Prasad C
Decompose it in to BCNF.

UNIT - V

Marks CO BL
10 Explain the implementation of Isolation and testing Serializability. 5(M) CO5 L5
(a)

(b) Explain Hash based indexing. 5(M) CO5 L5

11 Perform the operations of B+ tree, on the following data. 10(M) CO5 L5


5,3,21,9,13,22,7,11,14,8,16

**********

Page 3 of 3

You might also like