Scribd
Upload
26 views2 pages

DBMS

DBMS notes

Uploaded by

Ram Ram
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
26 views2 pages

DBMS

DBMS notes

Uploaded by

Ram Ram
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
You are on page 1/ 2

SKP Engineering College

Thiruvannamalai-606611.
BE/B.TECH DEGREE EXAMINATION CIAT -2
Max: 50 Marks
Time:1 Hr.30 Mins SEMESTER 04 – IT Date: 22-05-2024

CS3492-Database Management System


PART – A (10 Marks)
1. What is a transaction? (2)
2. What are ACID Properties? (2)
3. What is meant by concurrency control? (2)
4. What is the need for RAID? (2)
5. What are the disadvantages of B tree over B+ tree? (2)

PART – B (40 Marks)


6.(a) Write a short note on ACID Properties. (8)
(or)
6.(b) Write a short note on Transaction support in SQL with example. (8)

7.(a) Explain two phase locking in detail. (16)

(or)

7.(b) Explain dead lock handling in detail. (16)

8.(a) Briefly explain RAID and RAID levels. (16)

(or)

8.(b) (1) Briefly explain Dynamic Hashing.

(2) Differentiate between Static and Dynamic Hashing. (16)

Prepared By: MS.D.N.Rubiya Approved By: Dr.V.Raji


SKP Engineering College
Thiruvannamalai-606611.

You might also like