Advanced Database (CSC475) 2080 BS Past Questions & Solutions

Tribhuvan University (TU) 2080 BS board exam question paper with verified step-by-step solutions for BSc CSIT Eighth Semester.

TRIBHUVAN UNIVERSITY

INSTITUTE OF SCIENCE AND TECHNOLOGY

2080 B.S.

Bachelor Level: B.Sc. CSIT

Semester: Eighth Semester

Subject: Advanced Database (CSC475)

Full Marks: 60 / 80

Pass Marks: 24 / 32

Candidates are required to give their answers in their own words as far as practicable.

Group A

Long Answer Questions

Attempt any Two questions.

  1. 1
    Explain different features of enhanced ER (EER) model. Compare specialization with generalization.
  2. 2
    Compare object-oriented database with object relational database. What are different object database features that have been included in SQL?
  3. 3
    Why distributed database is important? What is transparency? Explain different types of transparencies in distributed databases.

Group B

Short Answer Questions

Attempt any Eight questions.

  1. 4
    Why hashing is important to store data in databases? What is primary file organization?
  2. 5
    Explain aggregation with suitable example.
  3. 6
    What is ODMG object model? What is object definition language (ODL)?
  4. 7
    Explain different steps in query processing.
  5. 8
    Why query optimization is essential in databases? What is heuristic optimization?
  6. 9
    Define fragmentation. Explain horizontal fragmentation with example.
  7. 10
    What are the characteristics of NOSQL systems? Explain.
  8. 11
    What is the concept of active database? What are triggers?
  9. 12
    Write short notes on: a. BigData b. Information retrieval

Related Study Resources for Advanced Database (CSC475)

Subject HubAdvanced Database (CSC475)Official CurriculumAdvanced Database SyllabusTU Board PapersAdvanced Database Past QuestionsSemester Directory8th Sem Subjects
Advanced Database (CSC475) 2080 BS Past Questions | BSc CSIT 8th Sem