Database Management System MCQ for Bihar STET with Answers, PYQs & Notes

Tests in this unit

• Mock TestThe 30-question Unit 6 mock paper from the notes, in book order.30 Q
• PYQ OnlyQuestions asked in the 2023, 2024 and 2025 STET papers.43 Q
• Practice BankTopic-wise questions: architecture, keys, ER model, normalization, transactions and SQL.68 Q
• Full TestPYQs and the practice bank together.111 Q
• Quick Test30 questions picked at random.30 Q

Unit 6 syllabus: Database Management System

1. Introduction to database; components and structure of DBMS; logical structure: the 3 level architecture and mapping among them; comparison between traditional file based system and DBMS; advantages and drawbacks of DBMS.
2. Relational model; relational key constraints: candidate key, primary key, foreign key. ER model: entities, attributes, relationship and cardinality; entity types, entity sets, attributes and keys; relationship types and relationship sets; converting ER diagram to relational tables; database schema.
3. Database anomalies, Codd's rules and normalization theory: 1NF, 2NF, 3NF and BCNF.
4. Introduction to transaction and concurrency control; transaction and system concepts; desirable properties of transactions; transaction support in SQL; concurrency control techniques: locking protocol, serializable schedules, locks, 2 phase commit; concurrency control based on timestamp ordering.