Short Answer Questions:
1. List any 4 transaction properties.2. What is DDBMS? Classify DDBMS?
3. What is distributed transparency?
4. What are the data allocation methods?
5. List the characteristics of Object-Oriented Data Model?
6. List four Advantages and disadvantages of
OODBMS?
7. List the main components of Decision Support Systems.
8. Compare ROLAP and MOLAP.
9. State what is data fragmentation.
10.Define Data Mining and state the need of data mining.
Long Answer Questions.
11.What are the twelve commandments of DDBMS? Explain in brief.12.(a).Explain the levels of data and process distribution.
(b).What are the advantages and disadvantages of DDBMS?
13.Define object and explain the various types of objects.
14. a) List the characteristics of Object-oriented data model.
b) What are the features of an OODBMS?
15. (a)Explain about DataWarehouse.
(b)write the difference between Operational Data and DSS data.
16.(a)Explain Star schema representation with neat diagram.
(b)List the characteristics of OLAP.
17.Explain Data Mining methodolegies.
18.Explain about Directed DataMining and Undirected Data Mining.
Prev Question Paper: ADBMS OCT/NOV 2009
PREVIOUS QUESTION PAPER: MARCH/APRIL 2008
Short Answer Questions:
1.What is a transaction log and what is its function?
2.Define: (a)Homogeneous distributed database and a Heterogeneous distributed database.(b)Distributed Data Catalog.
3.Explain Data Replication.
4.Write the features of a distributed Database Management systems.
5.What is an object -oriented data model? Write the characteristics of an OOData Model.
6.Define early binding and late binding.
7.Define DataWarehouse.
8.Explain ROLAP.
9.What is Data Mining.
10.Explain the usage of DataMining at present.
Long Answer Questions:
11. (a) Explain C.J.Date's twelve commandments for distributed database.
(b) Define the following: (i) Distributed Transaction.
(ii)Distributed Request.
12. (a) What is data fragmentation? Describe the 3 types of data fragmentation strategies.
(b) Explain distribution transparency.
13. Explain the advantages and disadvantages of an object oriented Database Management Systems.
14.(a) What is an object? Explain the classification of object according to the characteristics of its attributes.
(b) Explain the concept of inheritance and the different types of inheritance.
15.(a). What are the decision support systems? What are the main components of a decision support system.
(b). Explain the decision support system database requirements.
16.(a). Define On-line Analytical Processing(OLAP). What are the main characteristics of OLAP?
(b). Write the differences between Relational and Multidimensional OLAP.
17.(a). Explain the data mining methodolgy.
(b). Explain the differences between Data mining and OLAP.
18. Explain the following:
(a). Physical Datamining Structure.
(b). Directed Data mining.
