BSc CSIT (TU) Science Advanced Database (BSc CSIT, CSC461) Question Paper 2074
This is the official BSc CSIT (TU) (Science stream) Advanced Database (BSc CSIT, CSC461) question paper for 2074, 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 2074 paper is a great way to practise under real exam conditions.
Section A: Long Answer Questions
Attempt any TWO questions.
What is query processing? Explain the different steps involved in query processing and optimization with the help of a block diagram. Discuss how heuristic-based optimization transforms a relational algebra query into an efficient query plan.
What is a distributed database management system (DDBMS)? Explain data fragmentation, replication and allocation techniques used in distributed databases with suitable examples.
Explain the object-oriented database model. Discuss the ODMG object model along with the Object Definition Language (ODL) and Object Query Language (OQL) with examples.
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.