(SEM V) THEORY EXAMINATION 2017-18 DATABASE MANAGEMENT SYSTEM

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