(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
Related Notes
BASIC ELECTRICAL ENGINEERING
ENGINEERING PHYSICS THEORY EXAMINATION 2024-25
(SEM I) ENGINEERING CHEMISTRY THEORY EXAMINATION...
THEORY EXAMINATION 2024-25 ENGINEERING MATHEMATICS...
(SEM I) THEORY EXAMINATION 2024-25 ENGINEERING CHE...
(SEM I) THEORY EXAMINATION 2024-25 ENVIRONMENT AND...
Need more notes?
Return to the notes store to keep exploring curated study material.
Back to Notes StoreLatest Blog Posts
Best Home Tutors for Class 12 Science in Dwarka, Delhi
Top Universities in Chennai for Postgraduate Courses with Complete Guide
Best Home Tuition for Competitive Exams in Dwarka, Delhi
Best Online Tutors for Maths in Noida 2026
Best Coaching Centers for UPSC in Rajender Place, Delhi 2026
How to Apply for NEET in Gurugram, Haryana for 2026
Admission Process for BTech at NIT Warangal 2026
Best Home Tutors for JEE in Maharashtra 2026
Meet Our Exceptional Teachers
Discover passionate educators who inspire, motivate, and transform learning experiences with their expertise and dedication
Explore Tutors In Your Location
Discover expert tutors in popular areas across India
Discover Elite Educational Institutes
Connect with top-tier educational institutions offering world-class learning experiences, expert faculty, and innovative teaching methodologies