Advanced Database Management System - Tutorials and Notes: Anna University MCA MC 1654 – DATABASE MANAGEMENT SYSTEMS Question May June 2008

Search Engine

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

Wednesday, 17 February 2016

Anna University MCA MC 1654 – DATABASE MANAGEMENT SYSTEMS Question May June 2008

MC 1654 – Database Management Systems - May June 2008 Question Paper / Anna University MCA Exam May June 2008 Question Paper / MC1654 DBMS May June 2008 Question Paper / MC1654 Database Management Systems Previous Year MCA Question Paper / Anna University Affiliated Colleges MCA Question Papers / MC1654 DBMS Regulation 2005 MCA Question Paper / MCA Second Semester Question Paper

Question Paper Code :
(Regulation 2005)
Time : Three Hours                                                         Maximum : 100 marks
Answer ALL Questions
PART A – (10 X 2 = 20 marks)

1. Write any four major disadvantages of keeping organization information in a file processing system.
2. Define a weak and strong entity set.
3. What is a condition Box in the context of Query By example (QBE)?
4. Write the advantages and Disadvantages of 3 NF.
5. Difference between mirroring and striping.
6. What are Bitmap indices?
7. How can you measure the cost of a query?
8. List some of the useful statistical information about database relations as maintained by DBMS catalog.
9. Write any four properties of a transaction.
10. What is fuzzy check point?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Explain two methods for dealing with the deadlock problem ?
(ii) Write short note on shadow paging and buffer management.
(b) (i) Explain the distinction between the terms Serial Schedules and Serializable Schedules.
(ii) During its execution, a transaction passes through several stages, until it finally commits or aborts. List all possible sequences of stages through which a transaction may pass.
12. (a) Explain various data models with suitable examples for each.
(b) (i) Construct an E-R diagram with all major components for a banking enterprises with entity set customer, branch, loan, payment, account, employee with other own assumption.
(ii) Write short note on history of database system
13. (a) (i) Explain the fourth Normal Form (4NF).
(ii) Write short note on Embedded SQL.
(b) (i) Explain about Functional Dependencies (FD’s).
ii) Write short note on Embedded SQL.
14. (a) (i) Explain the physical characteristics of Disk.
(ii) What is RAID? Explain all the RAID levels.
(b) Explain B+ Tree index files.
15. (a) What do you mean by external sorting? Explain the merge sort technique and discuss its performance.
(b) How can you perform heuristic optimization? Explain the various heuristics in query optimization with examples


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