Advanced Database Management System 2069

Question Paper Details
Tribhuwan University
Institute of Science and Technology
2069
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 the questions.

Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

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

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...

10) Explain mobile computing architecture with suitable diagram.

6 marks
Details
Official Answer
AI Generated Answer

AI is thinking...