Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 8 · Model question
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 questions.(2 × 10 = 20)
- 1.10
Explain enhanced entity relationship model in detail. What is aggregation?
- 2.10
What is distributed database? Explain data fragmentation techniques in detail with suitable example.
Answer comingAlso asked in 2081
- 3.10
Why do we need query optimization in databases? Compare heuristic query optimization with cost-based query optimization.
Answer comingAlso asked in 2081, 2080
Group B
Attempt any EIGHT questions.(8 × 5 = 40)
- 4.5
Explain specialization and generalization with example.
Answer comingAlso asked in 2082, 2081
- 5.5
What are the benefits of object-oriented database? What is object identity?
- 6.5
Explain object query language (OQL) with suitable example.
Answer comingAlso asked in 2081, 2080, 2079
- 7.5
What is query tree? Why do we need this tree in query processing?
- 8.5
Explain different techniques for distributed database design.
Answer comingAlso asked in 2082
- 9.5
Explain document-based NOSQL system with example.
- 10.5
Explain multimedia database in brief. What are the different applications of multimedia database?
- 11.5
Why do we need temporal database? Explain different time dimensions in this database.
- 12.5
Write short notes on:
a) Indexing
b) MapReduce
— The End —