Unit-wise questions - Advanced Database Management System(old syllabus)

Syllabus Notes Old Questions & solutions Yearly Questions Text & reference books
22 questions

1) Explain the following terms:

     a) Database performance tuning

     b) UML

     c) Subclass vs Superclass

     d) X Query

     e) Calendars

     f) Active Database

asked in 2072

1. What is query processing? How is it different from query optimization? Discuss cost estimation for relational algebra expressions.

asked in 2076

1. Explain the following terms:

     a) Data replication

     b) UMI

     c) SOL: 2003

     d) Xpath

     e) SOAP

     f) Clustering

asked in 2074

1. Explain the following terms:

a. Spatial database

b. ECA model

c. Federated DBMS

d. Well-formed and valid XML document

e. GIS

f. Classification and clustering

asked in Model

1. How do you increase performance of the database? Explain any one database performance tuning technique with example. (2+4)

asked in 2075

1. Discuss query optimization with suitable example. What is the importance of query optimization in database? (4 + 2)

asked in 2077

2) What are query optimization techniques? Explain.

asked in 2072

2.What is data fragmentation? Discuss horizontal and vertical fragmentation in detail.

show solution

asked in 2076

2. What is query processing? How is it different from query optimization? Discuss heuristic query optimization.(1+2+3)

show solution

asked in 2075

2. How can you convert an EER design to a relational design? Discuss with suitable example.(6)

asked in 2077

3. What are the benefits of using distributed databases? Discuss different types of distributed database systems. (3+3)

show solution

asked in 2075

3. Discuss various type constructors used in object-oriented database. How are they used to create complex objects?(4+2)

asked in 2077

4. What is complex object? What is the difference between structured and unstructured complex objects?(1+5)

asked in 2077

5. Define object relational database. Discuss different types of knowledge discovered during data mining.(1+5)

asked in 2077

6. What is active database ? Discuss generalized mode for active databases?(2+4)

asked in 2077

6) Write a schema that provides tags for a person’s first name, last name, weight, and shoesize. Weight and shoe size tags should have attributes      to designate measuring systems.

asked in 2070

7. Discuss how time is represented in temporal databases and compare the different time dimensions.(3+3)

asked in 2077

8. Describe the main reasons for the potential advantage for distributed database. What additional functions does it have over centralized DBMS?

show solution

asked in 2071

8. What is data mining ? Discuss different types of knowledge discovered during data mining.(1+5)

asked in 2077

9. What is data warehouse ? How does it differ from a databases ?(2+4)

asked in 2077

10. Write short notes on:(2x3)

a) Integrity constraint

b) Mobile database

asked in 2075

10. What is mobile database? Discuss mobile computing architecture in detail.(1+5)

asked in 2077

13 questions

1. Discuss different constraints of specialization and generalization.

asked in 2073

2. Draw an ER diagram for a hospital with a set of patients and a set of doctors. Associate with each patient a log of various tests and examinations conducted.

asked in 2073

2. How does a category differ from a regular shared subclass? What is a category used for? Illustrate your answer with suitable examples.

                                          OR

Describe the steps of the algorithm for object database design by EER-to-OO mapping.

asked in Model

2) Draw an ER Diagram for a hospital with a set of patients and set of doctors associated with each patient a log of various tests and examinations conducted.

asked in 2070

2) How can you convert an ERR design to relational design? Discuss with suitable example.

asked in 2069

3) Differentiate between specialization and generalization with example.

asked in 2072

3. Define state of an object. Distinguish between persistent and transient objects.

asked in 2071

3.Why do we need extended ER modeling? Discuss class/subclass relationship with example.

asked in 2076

3. Explain the process of EER to relational mapping with example.

asked in 2074

3) What is the difference between an object and a..... in the object oriented data model (OOBM)?

asked in 2070

4) What are the main difference between designing a relational database and an object database?

asked in 2070

8) Distinguish object-oriented database and object relational databases.

asked in 2069

9) What are the advantages and disadvantages of extending the relational data model by means of ORDBMS?

asked in 2070

44 questions

1) Explain the following terms:

     a) Extent

     b) Temporal Database

     c) Degree of homogeneity of DBMS

     d) X Path

     e) Classification and clustering

     f) OLAP

asked in 2070

2. Distinguish multiple inheritance and selective inheritance in OO concepts.

asked in 2071

2. What is mobile computing? Explain its architecture.

asked in 2074

3. Define encapsulation? How is it used to create abstract data types?

asked in 2073

3. What is the difference between persistent and transient objects? How persistence is handled in typical OO database systems?

asked in Model

3) What is OID? How persistent objects are maintained in OO Database?

asked in 2069

4. What is versioning? Why is it important? What is the difference between versions and configurations?

asked in 2073

4) How do single inheritance, multiple inheritance and selective inheritance differ?

asked in 2072

4. Discuss how time is represented in temporal databases and compare the different time dimensions.

asked in 2071

4.How do object relational database support multi-valued and composite attributes? Discuss with example.

asked in 2076

4. Discuss the concept of encapsulation, and tell how it is used to create abstract data types.

asked in 2074

4. Describe different implementation issues with object relational database system.

asked in Model

4. What are the benefits of using object oriented databases over relational databases? Discuss different type of constructors used in object oriented databases. (2+4)

asked in 2075

4) Discuss the relative advantages of centralized and distributed database.

asked in 2069

5. What is object relational database? Discuss object relational features of SQL.

asked in 2073

5) What are the differences between structured and unstructured complex objects? Explain.

asked in 2072

5. What is the difference between structured and unstructured complex object?Differentiate identical versus equal objects with examples.

asked in 2071

5.What are the uses of active database? Discuss active database with example.

asked in 2076

5. What are the differences between structured and unstructured complex objects ? Explain

asked in 2074

5. Discuss the different technique for executing an equijoin of two files located at different sites. What main factors affect the cost of data transfer?

                                            OR

What are the main difference between designing a relational database and an object database?


asked in Model

5. Discuss different implementation issues related with object relational database. (6)

asked in 2075

5) Discuss some applications of active database. How do spatial databases differ from regular database?

asked in 2070

5) Describe different implementation issues with object relational database system.

asked in 2069

6. Define active database. Discuss some applications of active databases.

asked in 2073

6. What are the advantages and disadvantages of OODBMS?

asked in 2071

6.Discuss mobile computing architecture. Discuss mobile data management in detail.

asked in 2076

6. What is temporal database? Explain the terms date, time, timestamp, interval and period.

asked in 2074

6. Define GIS. Discuss different data modeling and representation for GIS data. (1+5)

asked in 2075

6) Discuss the different techniques for executing equijoin of two files located at different sites. What main factors affect the cost of data transfer?

asked in 2069

7. What is the difference between valid time, transaction time, and bitemporal relations?

asked in 2073

7) Discuss how time is represented in temporal database and compare different time dimensions.

asked in 2072

7.Why do we need temporal database? Discuss valid time, transaction time and bi-temporal relations.

asked in 2076

7. Explain mobile computing architecture with suitable diagram.

asked in Model

7. Define multimedia database. Discuss benefits of multimedia databases. How do you query image database? (1+2+3)

asked in 2075

7) Distinguish between structured and unstructured complex objects.

asked in 2070

8. What is multimedia database? What are the nature of multimedia database and applications?

asked in 2074

9) Describe multimedia database and what are the different types of multimedia data that are available in current systems?

asked in 2072

9. Describe the characteristics of mobile computing environment in detail.

asked in 2071

10. What is mobile database? Discuss the characteristics of mobile environments.

asked in 2073

10. What is GIS? What are GIS data operations?

asked in 2074

10.Write short notes on:Deductive database ODMG.

asked in 2076

10. Describe the main reasons for and potential advantages for distributed database. What additional functions does it have over centralized DBMS?

asked in Model

10) Enumerate the limitations of conventional database compared to multimedia database.

asked in 2070

10) Explain mobile computing architecture with suitable diagram.

asked in 2069

11 questions

1. Explain the following terms:

     a) Data Warehouse

     b) Distribution Transparency

     c) X Query

     d) Distribution transaction

     e) Knowledge base

     f) Classification and clustering

asked in 2071

1) Explain the following terms:

     a) Data mining

     b) ECA model

     c) Spatial database

     d) Specialization and generalization in an ERR model

     e) XML and HTML

     f) GIS

asked in 2069

7.What is data warehouse? Explain the architecture for the functionality of data warehouse.

asked in 2074

8. What is data mining? Discuss data mining as a part of knowledge discovery process.

asked in 2073

8.Discuss benefits and applications of data mining. How is classification different from clustering?

asked in 2076

8. Discuss data warehouse and its functionality. Discuss association rule mining with example. (3+3)

asked in 2075

8) What is data warehouse? List the characteristics of data warehouse.

asked in 2070

9. What is data warehouse? Discuss the typical functionality of data warehouse.

asked in 2073

9. What is data mining? Discuss association rule mining with example. 

asked in 2074

9. What is a data warehouse? How does it differ from a database?

                                            OR                        

Describe multimedia database and what are the different types of multimedia data that are available in current systems?

asked in Model

9) What is a data warehouse? How does it differ from a database?

asked in 2069

10 questions

6) What are the object relational features that have been included in SQL-99?

asked in 2072

6. Differentiate between attributes and elements in XML? List some of the important attributes used in specifying elements in XML schema.

                                               OR

What is the difference between structured and unstructured complex object? Differentiate identical versus equal objects with examples.

asked in Model

7. What are the differences and similarities between objects and literals in the ODMG object model?

asked in 2071

7) Differentiate between attributes and elements in XML? List some of the important attributes used in specifying elements in XML schema.

asked in 2069

8) What are the difference and similarities between objects and literals in the ODMG Object Model?

asked in 2072

8. What are the difference and similarities between objects and literals in the ODMG Object Model?

asked in Model

9.What is web service? Discuss SOAP in detail.

asked in 2076

9. What is web service? Discuss SOAP in detail. (2+4)

asked in 2075

10) Explain XML schema and XML DTD.

asked in 2072

10. Differentiate between XML schema and XML DTD with suitable example.

asked in 2071