Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Tribhuwan University

Institute of Science and Technology

2080

Bachelor Level / Fourth Year / Eighth Semester / Science

B.Sc in Computer Science and Information Technology (CSC475)

(Advanced Database)

Full Marks: 60

Pass Marks: 24

Time: 3 Hours

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

The figures in the margin indicate full marks.

Section A

Long Answers Questions

Attempt any TWO questions.
[2*10=20]
1.
Explain different features of enhanced ER(EER) model. Compare specialization with generalization.[10]
2.
Compare object oriented database with object relational database. What are different object database features that have been included in SQL?[10]
3.
Why distributed database is important? What is transparency? Explain different types of transparencies in distributed databases.[10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
Why hashing is important to store data in databases? What is primary file organization? [5]
5.
Explain aggregation with suitable example. [5]
6.
What is ODMG object model? What is object definition language? [5]
7.
Explain different steps in query processing. [5]
8.
Why query optimization is essential in databases? What is heuristic optimization? [5]
9.
Define fragmentation. Explain horizontal fragmentation with an example. [5]
10.
What are the characteristics of NOSQL Systems? [5]
11.
What is the concept of active database? What are triggers? [5]
12.
Write short notes on: a) Big data b) Information retrieval [5]