Advanced Database Management System - Tutorials and Notes: MC 9213/MC 913 – DATABASE MANAGEMENT SYSTEMS - May/June 2013

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Monday, 23 June 2014

MC 9213/MC 913 – DATABASE MANAGEMENT SYSTEMS - May/June 2013

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)

_____________________



Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents