TRIBHUVAN UNIVERSITY
INSTITUTE OF SCIENCE AND TECHNOLOGY
2082 B.S.
Candidates are required to give their answers in their own words as far as practicable.
Group A
Long Answer QuestionsAttempt any Two questions.
- 1Discuss 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.
- 2List the types of transparency in distributed database. Explain the distributed database architecture.
- 3How 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
Short Answer QuestionsAttempt any Eight questions.
- 4Discuss the replication and allocation techniques for distributed database design.
- 5State CAP theorem. What is meant by cost based query optimization?
- 6Explain the features of NOSQL system.
- 7Discuss the two main types of constraints on specializations and generalizations.
- 8Discuss about super type and sub type with an example.
- 9Distinguish between dis-jointness and overlap constraints.
- 10Describe about the different graphical notations for representing ODL schemas.
- 11How do you map EER to relation? Illustrate with an example.
- 12How do you specify object persistence via naming and reachability?