MC 9213/MC 913 – Database Management Systems - May June 2013 Question Paper / Anna University MCA Exam May June 2013 Question Paper / MC9213 DBMS May June 2013 Question Paper / MC9213 Database Management Systems Previous Year Question Paper / Anna University Affiliated Colleges MCA Question Papers / MC9213 Database Management Systems Previous Year Question Paper according to Regulation 2009
Question
Paper Code : 70705
M.C.A
DEGREE EXAMINATION, MAY/JUNE 2013
First
Semester
MC
9213/MC 913 – DATABASE MANAGEMENT SYSTEMS
(Regulation
2009)
Time
: Three Hours Maximum
: 100 marks
Answer
ALL Questions
PART
A – (10 X 2 = 20 marks)
1. What is logical data independence?
2. List out the functionalities of DBA.
3. What is a candidate key? Give example.
4. Define view in SQL.
5. What do you mean by hashing?
6. What is data dictionary?
7. What is database tuning?
8. Define normalization.
9. List the desirable properties of transaction.
10. What is concurrency control?
PART
B – (5 X 16 = 80 marks)
11. (a) Explain the
architecture of a DBMS with diagrammatic illustration. (16)
Or
(b) Model a ER diagram
for a library management system. State the functional requirements you are
taking into consideration. (16)
12. (a) Explain Cartesian
product. Natural join, left outer join, right outer join and full outer join in
relational algebra with examples. (16)
Or
(b) Explain with
examples in SQL the following:
(i) Aggregate
functions. (8)
(ii) GROUP BY (2)
(iii) ORDER BY (2)
(iv) Trigger (4)
13. (a) Describe in
detail about sequential file organization and random file organization. (16)
Or
(b) Explain B+ tree
index files and B tree index files with examples. (16)
14. (a) Explain 1NF,
2NF, and 3NF with examples. (16)
Or
(b) Explain with an
example the steps involved in processing a query. (16)
15. (a) (i) What is
meant by concurrent execution of database transactions in a multi-user system?
Discuss why concurrency control is needed? Give suitable example. (8)
(ii) Explain two
phase locking protocol with an example. (8)
Or
(b) (i) Draw a state
diagram and discuss the typical states that a transactions goes through during
execution. (8)
(ii) Explain with
examples read only transaction and read write transaction. (4)
(iii) What is crash
recovery? Discuss. (4)
_____________________