KERALA UNIVERSITY Class 5 database design Question Paper 2019

Practice authentic previous year questions for better exam preparation.

Sample Questions

(a) Explain the different lock based protocols for concurrency control. ..... 15
(b) What are the ACID properties of a transaction? ..... 5 OR
(a) Explain the procedure for insertion into a $B$ tree. Create a $B$ tree of order $p=3$ by inserting values in the sequence $64,22,3,45,1,88,34,99,24$, 5, 2, 77.
(b) Briefly explain the advantages of a DBMS system over a file system.
(a) Create a table Weather with the following structure using SQL | Name of Column | Type | | :--- | :--- | | City | Character(15) | | Temperature | Number(2) | | Humidity | Number(2) | | Condition | Character(20) | | Country | Character(20) | Crea...