[go: up one dir, main page]
Scribd
Upload
9 views1 page

DBMS Paper

The document outlines the instructions for the B. Tech 4th Semester 2nd Mid Term Exam in Database Management System at Sawai Madhopur College of Engg. & Technology. Candidates are required to attempt any six questions from a list of nine, covering various topics such as ER Modeling, normalization, and database recovery schemes. The exam duration is 1.5 hours and carries a total of 30 marks.

Uploaded by

Anjum Nisha
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
9 views1 page

DBMS Paper

The document outlines the instructions for the B. Tech 4th Semester 2nd Mid Term Exam in Database Management System at Sawai Madhopur College of Engg. & Technology. Candidates are required to attempt any six questions from a list of nine, covering various topics such as ER Modeling, normalization, and database recovery schemes. The exam duration is 1.5 hours and carries a total of 30 marks.

Uploaded by

Anjum Nisha
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/ 1

Sawai Madhopur College of Engg.

& Technology
B. Tech 4th Semester 2nd Mid Term Exam 2024-25 Branch:- CS Sub:- Database Management System

Instruction to Candidates: Time:- 1:30 hour Marks:- 30


Attempt any Six questions. All question carry equal marks.
1. Explain ER Modeling in DBMS.
2. Explain the File System v/s DBMS.
3. Explain the Boyce-Codd Normal forms.
4. Explain the recovery schemes is Database.
5. What you mean by Null Values and Embedded SQL?
6. Explain the Validation-based protocols.
7. What is difference between strict two-phase locking and simple two-phase locking protocols?
8. What is the role of normalization in database design? Explain the first normal form, second normal
form, third normal form and BCNF with example of each?
OR
9. What are the keys? Explain the candidate key & primary key with examples.

Sawai Madhopur College of Engg. & Technology


B. Tech 4th Semester 2nd Mid Term Exam 2024-25 Branch:- CS Sub:- Database Management System

Instruction to Candidates: Time:- 1:30 hour Marks:- 30


Attempt any Six questions. All question carry equal marks.
1. Explain ER Modeling in DBMS.
2. Explain the File System v/s DBMS.
3. Explain the Boyce-Codd Normal forms.
4. Explain the recovery schemes is Database.
5. What you mean by Null Values and Embedded SQL?
6. Explain the Validation-based protocols.
7. What is difference between strict two-phase locking and simple two-phase locking protocols?
8. What is the role of normalization in database design? Explain the first normal form, second normal
form, third normal form and BCNF with example of each?
OR
9. What are the keys? Explain the candidate key & primary key with examples.

You might also like