What is concurrency control? Name various methods of controlling the concurrency control? Differentiate between Binary lock and shared/Exclusive lock. [10]
2.
Define schedule and serializability. How can you test the serializability? [5]
3.
What is Granularity of data items? How does it effect in concurrency control? [5]
4.
Explain 2 phase locking technique in brief. [5]
Data Modeling Using the Entity-Relational Model
1.
What is difference between Entities and Entity sets? Explain with example. [5]
Database and Database
1.
What are the advantages of using Database Management System over traditional filing system? Explain different data models with example. [10]
Database Recovery Techniques
1.
What are the different approaches of Database recover? What should log file maintain in log-based recovery? [5]
Database System – Concepts and Architecture
1.
What is data abstraction? What are three levels of data abstraction? Explain. [5]
Relational Database Design
1.
What is normal form? Explain their types. Explain about loss-less join decomposition. [10]
SQL
1.
Create two table Courses (CID, Course, Dept) and HoD (Dept, Head) using SQL language with all constraints [Primary key, Foreign key and Referential Integrity]. Assume the types of attributes by your own. [5]
The Relational Data Model and Relational Database Constraints
1.
Differentiate between Integrity and Security with example. [5]
2.
Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key? [5]