Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 8 · TU Board 2082
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
Discuss the reasons for converting SQL queries into relational algebra. What is meant by the term heuristic optimization? Discuss the main heuristics that are applied during query optimization with an example.
- 2.10
List the types of transparency in distributed database. Explain the distributed database architecture.
- 3.10
How do spatial databases differ from regular databases? What are deductive databases? How do you apply trigger in active database? Illustrate with an example.
Group B
Attempt any EIGHT questions(8 × 5 = 40)
- 4.5
Discuss the replication and allocation techniques for distributed database design.
Answer comingAlso asked in Model question
- 5.5
State CAP theorem. What is meant by cost based query optimization?
- 6.5
Explain the features of NOSQL system.
Answer comingAlso asked in 2080, 2079
- 7.5
Discuss the two main types of constraints on specializations and generalizations.
Answer comingAlso asked in 2081, Model question
- 8.5
Discuss about super type and sub type with an example.
- 9.5
Distinguish between dis-jointness and overlap constraints.
- 10.5
Describe about the different graphical notations for representing ODL schemas.
- 11.5
How do you map EER to relation? Illustrate with an example.
- 12.5
How do you specify object persistence via naming and reachability?
— The End —