Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 8 · TU Board 2081
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 different object database concepts in brief. What are type constructors?
- 2.10
Why do we need query optimization in databases? Explain heuristic query optimization with examples.
Answer comingAlso asked in 2080, Model question
- 3.10
Explain different distributed database architectures. What is data fragmentation?
Answer comingAlso asked in Model question
Group B
Attempt any EIGHT questions.(8 × 5 = 40)
- 4.5
Explain different constraints of specialization and generalization.
Answer comingAlso asked in 2082, Model question
- 5.5
What is hashing? How does hashing improve database efficiency?
- 6.5
Explain ODMG object model.
Answer comingAlso asked in 2080, 2079, Model question
- 7.5
What are the uses of query trees in query processing? Explain.
- 8.5
What is the CAP theorem? Explain.
Answer comingAlso asked in 2079
- 9.5
What is Big Data? What are its 3 V's?
Answer comingAlso asked in 2080
- 10.5
What are triggers? What are the uses of triggers?
- 11.5
Why do we need spatial databases? What are common types of analysis for spatial data?
- 12.5
Write short notes on:
a) Map Reduce
b) Multimedia database
— The End —