Scribd
Upload
4 views2 pages

Model Question Paper

This document is a model question paper for a Database Management System (DBMS) exam, structured into four groups with varying marks. Group A consists of 10 one-mark questions, Group B has 5 two-mark questions, Group C includes 5 six-mark questions, and Group D contains 2 ten-mark questions. The questions cover fundamental DBMS concepts, relational database operations, normalization, and transaction management.

Uploaded by

lkmudi42
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Model Question Paper

This document is a model question paper for a Database Management System (DBMS) exam, structured into four groups with varying marks. Group A consists of 10 one-mark questions, Group B has 5 two-mark questions, Group C includes 5 six-mark questions, and Group D contains 2 ten-mark questions. The questions cover fundamental DBMS concepts, relational database operations, normalization, and transaction management.

Uploaded by

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

Database Management System (DBMS)

Model Question Paper

Time: 3 Hours
Full Marks: 70

Group A (10 × 1 = 10 Marks)


Answer all questions.

1. Define DBMS.
2. What is a schema?
3. What is a primary key?
4. Define entity.
5. What is a weak entity?
6. What is data independence?
7. What is a foreign key?
8. What is normalization?
9. State any one ACID property.
10. What is a transaction?

Group B (5 × 2 = 10 Marks)
Answer any five questions.

11. Differentiate between DBMS and File System.


12. What is metadata?
13. Define candidate key and super key.
14. Explain referential integrity.
15. What is a composite attribute?
16. Write the syntax of CREATE TABLE.
17. Define functional dependency.
18. What is serializability?

Group C (5 × 6 = 30 Marks)
Answer any five questions.

19. Explain the three-schema architecture of DBMS with a diagram.


20. Draw and explain an ER diagram for a Library Management System.
21. Discuss different types of keys used in a relational database.
22. Explain the following Relational Algebra operations with examples:

 Selection
 Projection
 Join

23. Write SQL queries for:

 Create a Student table


 Insert records
 Update records
 Delete records

24. Explain normalization. Convert a relation from 1NF to 3NF with suitable examples.
25. Discuss ACID properties of a transaction.
26. Explain different types of JOINs in SQL with examples.

Group D (2 × 10 = 20 Marks)
Answer any two questions.

27. (a) Explain the ER Model and its components.


OR
(b) Discuss entity integrity and referential integrity constraints with examples.
28. (a) Explain normalization up to BCNF with suitable examples.
OR
(b) Explain functional dependency, partial dependency, and transitive dependency.
29. (a) Describe transaction processing and concurrency control techniques.
OR
(b) Explain serializability and deadlock handling in DBMS.
30. (a) Explain database recovery techniques and checkpointing.
OR
(b) Discuss database security, authorization, and backup mechanisms.

You might also like