BSc CSIT (TU) Science Database Management System (BSc CSIT, CSC260) Question Paper 2081
This is the official BSc CSIT (TU) (Science stream) Database Management System (BSc CSIT, CSC260) 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 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 2081 paper is a great way to practise under real exam conditions.
Section A: Long Answer Questions
Attempt any TWO questions.
Explain Boyce-Codd Normal Form (BCNF). Differentiate it from 3NF and decompose a given relation into BCNF with an example.
Define a transaction and explain its ACID properties. Discuss the various states of a transaction with a state diagram.
Explain concurrency control. Describe the timestamp-based protocol and the two-phase locking (2PL) protocol for concurrency control.
Section B: Short Answer Questions
Attempt any EIGHT questions.
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.
What is a deadlock in a database? How is it handled?
Define schedule. Differentiate between serial and serializable schedules.
Explain the concept of a stored procedure.
What is data redundancy? How does normalization reduce it?