Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 8 · TU Board 2080
Course Title: Advanced Database (CSC461)
Full Marks: 60Pass Marks: 24Time: 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.
Group A
Attempt any TWO question.(2 × 10 = 20)
- 1.10
Explain different features of enhanced ER(EER) model. Compare specialization with generalization.
- 2.10
Compare object oriented database with object relational database. What are different object database features that have been included in SQL ?
- 3.10
Why distributed database is important? What is transparency? Explain different types of transparencies in distributed databases.
Group B
Attempt any EIGHT question.(8 × 5 = 40)
- 4.5
Why hashing is important to store data in databases? What is primary file organization?
- 5.5
Explain aggregation with suitable example.
- 6.5
What is ODMG object model? What is object definition language?
Answer comingAlso asked in 2081, 2079, Model question
- 7.5
Explain different steps in query processing
Answer comingAlso asked in 2079
- 8.5
Why query optimization is essential in databases? What is heuristic optimization?
Answer comingAlso asked in 2081, Model question
- 9.5
Define fragmentation. Explain horizontal fragmentation with an example.
- 10.5
What are the characteristics of NOSQL Systems?
Answer comingAlso asked in 2082, 2079
- 11.5
What is the concept of active database? What are triggers?
Answer comingAlso asked in 2079
- 12.5
Write short notes on: a) Big data b) Information retrieval
Answer comingAlso asked in 2081
— The End —