Monday, May 19, 2014

241204 Database Technology question paper - June 2011

241204 Database Technology question paper - June 2011 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers

Question Paper Code : 31283
Common to M.E. Computer Science and Engineering / M.E. Computer and Communications
Second Semester
Computer Science and Engineering

(Regulation 2010)

Time: Three hours                                                       Maximum: 100 Marks
Answer ALL Questions

PART A — (10 × 2 = 20 Marks)

1. State the advantages of Distributed databases.
2. List the types of data fragmentation. Give reasons for fragmenting a relation in the distributed system.
3. What is persistence in object oriented database? Why it is important?
4. How does the concept of an object in the object oriented model differ from the concept of an entity in the entity-relationship model?
5. Compare and contrast data warehouse and operational database.
6. Specify the different categories of data available in the mobile databases.
7. How do spatial databases differ from regular databases?
8. What is multi-valued dependency? Specify the procedure for eliminating it from a relation.
9. Mention the applications of deductive databases.
10. What are the different types of multimedia sources?

PART B — (5 × 16 = 80 Marks)

11. (a) Explain the issues that are addressed for a distributed database design. (16)
(b) (i) During the transaction execution, it passes through several states, until it finally commits or aborts. List all possible sequences of states through which a transaction may pass. Explain why each state transition may occur. (6)
(ii) Consider the following undo/redo log with check pointing (CKPT). The third and fourth values in the entries that have 4 values are the old and the new value, respectively.
<T1, A, 4, 5>
<T2, B, 9, 10>
<T3, C, 14, 15>
Suppose that there is a crash, and the last log entry to appear on disk is <T2, B, 9, 10>. That is, only the first 4 log entries shown above actually appear in the log. The remaining 7 entries are never recorded in the log. Describe the actions of the recovery manager, including changes to both the disk and log. Describe the actions at recovery time. Specify the actions happened in the disk and log for both the cases. (10)
12. (a) (i) What are main features of object oriented database? How it is advantageous over RDBMS? (8)
(ii) Compare inheritance in the Extended ER model to in heritance in the object oriented model with an example. (8)
(b) Discuss in detail about the concurrency control in object oriented databases. (16)
13. (a) (i) Explain the various client/server architectures commonly used in the database environment. (8)
(ii) Explain web databases in detail. (8)
(b) (i) What is data mining? How does data mining technology relate to data warehousing technology? (8)
(ii) Describe the steps of building a data warehouse. (8)
14. (a) What is meant by the term heuristic optimization? Discuss the main heuristics that are applied during the query optimization. (16)
(b) Suppose that a city transportation department would like to perform data analysis on highway traffic for the planning the highway construction based on the city traffic data collected at different hours every day. Design a spatial database for the given scenario, to store the highway traffic information such as average and peak time traffic flow by highway, by time of day, and by weekdays, and the traffic situation when a major accident occurs. (16)
15. (a) Discuss the features of active databases and deductive databases. (16)
(b) (i) What are parallel databases? What are its benefits? (8)
(ii) Explain multimedia databases in detail. (8)


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

data recovery