Scribd
Upload
20 views1 page

DBMS Assignment - 4

This document is an assignment for the Database Management System course at ABES Engineering College for the 2024-25 academic session. It includes five questions related to transaction properties, schedules, log files, distributed databases, and deadlocks, each worth 4 marks. The assignment is due for submission on December 20, 2024.

Uploaded by

sanayasumpir
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
20 views1 page

DBMS Assignment - 4

This document is an assignment for the Database Management System course at ABES Engineering College for the 2024-25 academic session. It includes five questions related to transaction properties, schedules, log files, distributed databases, and deadlocks, each worth 4 marks. The assignment is due for submission on December 20, 2024.

Uploaded by

sanayasumpir
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

ABES Engineering College, Ghaziabad

Department of Computer Science & Engineering-Data Science

Session: 2024-25 Semester: V Section: C


Subject Code: BCS501 Subject Name: Database Management System

ASSIGNMENT NO. 4

Date of Assignment:17-12-2024 Date of submission: 20-12-2024

[Link]. CO Question Marks

What do you mean by transaction? Explain transaction property with


1. CO4 4
detail and suitable example
CO4 Define schedule? Define the concept of recoverable, cascadeless and 4
2.
strict schedules
CO4 Explain log file? Write the steps for log-based recovery of a system
3. with suitable example. 4

CO4 Define distributed databases? What are the advantages and


4. disadvantages of distributed databases? 4

CO4 • Explain deadlock? Describe methods to handle a deadlock.


5. • Discuss about the deadlock prevention schemes. 4

You might also like