BSc CSIT (TU) Science Database Management System (BSc CSIT, CSC260) Question Paper 2079
This is the official BSc CSIT (TU) (Science stream) Database Management System (BSc CSIT, CSC260) question paper for 2079, 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 Database Management System (BSc CSIT, CSC260) 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) Database Management System (BSc CSIT, CSC260) exam or solving previous years' question papers, this 2079 paper is a great way to practise under real exam conditions.
Section A: Long Answer Questions
Attempt any TWO questions.
Explain database recovery. Discuss log-based recovery techniques, deferred and immediate database modification, and the concept of checkpoints.
Explain indexing in databases. Differentiate between primary, secondary, and clustering indexes, and explain the structure of a B+ tree index.
Discuss functional dependency and its inference rules (Armstrong's axioms). Explain how to compute the closure of a set of attributes with an example.
Section B: Short Answer Questions
Attempt any EIGHT questions.
What are the different types of database users?
Differentiate between primary key, candidate key, and foreign key.
Explain the concept of a weak entity set with an example.
What is a view in SQL? Explain its advantages.
Differentiate between the DELETE, DROP, and TRUNCATE commands.
Explain aggregate functions in SQL with examples.
What is a trigger? Explain with an example.
Differentiate between relational algebra and relational calculus.
Explain lossless join and dependency-preserving decomposition.