Advanced Database Management System 2072

Tribhuwan University

Institute of Science and Technology

2072

Bachelor Level / Seventh Semester / Science

Computer Science and Information Technology ( CSC-401 )

( Advanced Database Management System )

Full Marks: 60

Pass Marks: 24

Time: 3 hours

Candidates are required to give their answers in their own words as far as practicable.

The figures in the margin indicate full marks.

Attempt all Questions.

1) Explain the following terms:

a) Database performance tuning

b) UML

c) Subclass vs Superclass

d) X Query

e) Calendars

f) Active Database

6 marks view

2) What are query optimization techniques? Explain.

6 marks view

3) Differentiate between specialization and generalization with example.

6 marks view

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

6 marks view

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

6 marks view

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

6 marks view

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

6 marks view

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

6 marks view

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

6 marks view

10) Explain XML schema and XML DTD.

6 marks view