About this previous year paper
DATABASE MANAGEMENT SYSTEM (NCS-502)
B.Tech | Semester V | Section-wise Important Questions & Notes
SECTION A – Very Short Answer (10 × 2 = 20 Marks)
This section checks basic definitions and core concepts. Answers should be short, crisp, and to the point.
Important Questions
Explain Specialization Write advantages of database system
Define DML Explain Logical Data Independence
Explain Entity Integrity Constraint Define Second Normal Form (2NF)
Explain Isolation (I) in ACID properties Define Schedule
Define Exclusive Lock Explain Replication in distributed database
Key Notes
Specialization: Top-down design approach in ER model
Logical data independence: Changes in logical schema do not affect application programs
Entity integrity: Primary key cannot be NULL
Isolation: Transactions execute independently
These are definition-based questions, so avoid long explanations
SECTION B – Short Answer (Attempt Any 3, 10 × 3 = 30 Marks)
This section needs concept explanation with examples.
Important Questions
Role of Database Administrator (DBA)
Explain Join and its types with example
What is Trigger? Explain different triggers with example
Difference between BCNF and 3NF
Explain Two-Phase Locking (2PL) with example
Key Notes
DBA manages security, backup, tuning, and users Join types: Inner, Left, Right, Full
Triggers: Before, After, Instead of BCNF is stricter than 3NF
2PL ensures serializability but may cause deadlock
SECTION C – Concurrency Control (10 Marks)
Important Questions
Explain Serializability
Difference between Conflict and View Serializability Methods for testing serializability
Explain Multiversion Concurrency Control (MVCC) Explain Timestamping Protocols
Key Notes
Serializability ensures correct concurrent execution Conflict serializability uses precedence graph
MVCC allows multiple versions of data items Timestamp ordering avoids deadlocks