BSc CSIT (TU) Science Advanced Database (BSc CSIT, CSC461) Question Paper 2081
This is the official BSc CSIT (TU) (Science stream) Advanced Database (BSc CSIT, CSC461) question paper for 2081, as set in the regular annual examination. It carries 60 full marks and a time allowance of 180 minutes, across 12 questions. On Kekkei you can attempt this Advanced Database (BSc CSIT, CSC461) past paper online with a timer, get instant AI feedback and step-by-step solutions, and track the topics where you lose marks — completely free. Whether you are revising for your BSc CSIT (TU) Advanced Database (BSc CSIT, CSC461) exam or solving previous years' question papers, this 2081 paper is a great way to practise under real exam conditions.
Section A: Long Answer Questions
Attempt any TWO questions.
What is a NoSQL database? Explain the characteristics of NoSQL systems and discuss the CAP theorem. Compare document-based, key-value, column-based and graph-based NoSQL data stores.
Explain the Enhanced Entity-Relationship (EER) model. Discuss specialization, generalization, categorization and aggregation with suitable diagrams and examples.
What is a data warehouse? Explain its architecture, the concept of OLAP and the star schema, and differentiate between OLTP and OLAP systems.
Section B: Short Answer Questions
Attempt any EIGHT questions.
Why is hashing important to store data in databases? What is primary file organization?
Explain aggregation with a suitable example.
What is the ODMG object model? What is Object Definition Language (ODL)?
Explain the different steps in query processing.
Why is query optimization essential in databases? What is heuristic optimization?
Define fragmentation. Explain horizontal fragmentation with an example.
What are the characteristics of NoSQL systems? Explain.
What is the concept of an active database? What are triggers?
Write short notes on: (a) Big Data (b) Information Retrieval.