TERM END EXAMINATIONS
MASTER OF COMPUTER APPLICATION, SEMESTER/YEAR–1
DATA BASE MANAGEMENT SYSTEM
Duration -3 Hrs Max Marks: 100
Note: 1. Attempt any five questions.
2. All question carry equal marks.
Q1. List down advantages of RDBMS over traditional file system. And explain the role of Database administrator.
Q2. What is Normalization? Explain the various types of normalization with its advantages and disadvantages?
Q3. What is meant by the concurrent execution of database transaction in a multi-user system? Discuss why concurrency control is needed, discuss with some examples
Q4. Explain various Recovery techniques.
Q5. Explain the following:
i) ACID Properties
iv) Two Phase locking Protocol
Q6 (a) What are Indexes? Explain the use of Indexes.
(b) Explain how you can optimize your Query.
Q7. Write SQL Query for following Table:
|1||Prof. Arun Nair||DBMS|
- I. Find No. of students in MCA I
- II. Who is teacher of Ramesh?
- III. Find No. of students for OS Course
- IV. What is class of Prof.Arun Nair
- V. List the names of students those who are attending Java Classes
Q8. (a) What is the need of Backup in a database system?
(b) Describe the methods used for Backup and recovery?
(c) What is the purpose of Rollback?
Q9. (a) What do you understand from functional dependencies?
(b) What is data redundancy? How does it affect consistency?
(c) Explain Data Independence and its types in brief.