DBMS (MCA-541) – COMPLETE QUESTION BANK

📘 DBMS (MCA-541) – COMPLETE QUESTION BANK

---

🔷 UNIT 1: INTRODUCTION & ER MODELING

Long Answer Questions

1. What is DBMS? Explain its characteristics and advantages over file system.

2. Explain the three-level architecture of DBMS with diagram.

3. What is data independence? Explain logical and physical data independence.

4. Explain ER model with its components.

5. Explain mapping cardinality with suitable examples.

6. Explain keys in DBMS (super, candidate, primary, foreign).

7. Explain generalization and aggregation in ER model.

8. Explain reduction of ER diagram into relational tables.

9. Explain extended ER (EER) model.

10. Explain relationships of higher degree (unary, binary, ternary).

Short Answer Questions

1. Define schema and instance.

2. What is a database?

3. Define entity and entity set.

4. What is an attribute?

5. What is a weak entity?

6. Define mapping constraints.

7. What is aggregation?

8. Difference between schema and instance.

9. What is DBA?

10. What is conceptual schema?

---

🔷 UNIT 2: RELATIONAL DATA MODEL & LANGUAGE

Long Answer Questions

1. Explain relational data model with its basic concepts.

2. Explain integrity constraints in DBMS.

3. Explain entity integrity and referential integrity with examples.

4. Explain domain constraints and key constraints.

5. Explain relational algebra operations.

6. Explain different types of joins in relational algebra.

7. Explain tuple relational calculus.

8. Explain domain relational calculus.

Short Answer Questions

1. Define relation, tuple and attribute.

2. What is domain?

3. Define degree and cardinality.

4. What is relational algebra?

5. Difference between relational algebra and relational calculus.

6. What is a foreign key?

7. What is entity integrity?

8. What is referential integrity?

9. Define constraint.

10. What is selection and projection?

---

🔷 UNIT 3: SQL (FOCUS ON JOINS, CURSOR, TRIGGERS, CLUSTERS)

Long Answer Questions

1. Explain SQL and its characteristics.

2. Explain types of SQL commands with examples.

3. Explain INNER JOIN and SELF JOIN with SQL queries.

4. Explain cursors in SQL/PL-SQL.

5. Explain triggers with types and examples.

6. Explain clusters in SQL.

7. Explain views and their advantages.

8. Explain aggregate functions in SQL.

9. Explain subqueries with examples.

10. Explain UNION, INTERSECTION and MINUS.

Short Answer Questions

1. What is SQL?

2. Define cursor.

3. What is an implicit cursor?

4. What is an explicit cursor?

5. Define trigger.

6. Difference between trigger and procedure.

7. What is a cluster?

8. What is a view?

9. What is an index?

10. Difference between DELETE and TRUNCATE.

---

🔷 UNIT 4: DATABASE DESIGN & NORMALIZATION (VERY IMPORTANT)

Long Answer Questions

1. What is functional dependency? Explain its types.

2. Explain partial and transitive dependency.

3. Explain normalization and its need.

4. Explain 1NF with example.

5. Explain 2NF with example.

6. Explain 3NF with example.

7. Explain BCNF with example.

8. Convert a table from 1NF to 2NF.

9. Convert a table from 2NF to 3NF.

10. Differentiate between 3NF and BCNF.

11. Explain multivalued dependency.

12. Explain join dependency.

Short Answer Questions

1. Define functional dependency.

2. What is normalization?

3. What are anomalies?

4. Define partial dependency.

5. Define transitive dependency.

6. What is BCNF?

7. Difference between 2NF and 3NF.

8. What is multivalued dependency?

9. What is lossless decomposition?

10. What is dependency preservation?

---

🔷 UNIT 5: TRANSACTION PROCESSING & SYSTEM ARCHITECTURE

Long Answer Questions

1. What is transaction processing? Explain transaction states.

2. Explain ACID properties of a transaction.

3. Explain concurrency control in DBMS.

4. Explain problems of concurrency.

5. Explain deadlock and its handling techniques.

6. Explain timestamp-based protocol.

7. Explain lock-based protocols.

8. Explain client-server architecture.

9. Explain parallel database architecture.

10. Explain traditional vs distributed database architecture.

Short Answer Questions

1. Define transaction.

2. What is serializability?

3. What is deadlock?

4. What is concurrency?

5. Define timestamp.

6. What is two-phase locking?

7. What is client-server system?

8. What is centralized database?

9. What is parallel system?

10. What is distributed database?

---

✅ HOW TO USE THIS LIST

Prepare all long questions → guaranteed coverage

Revise short questions → 2–4 marks secure

Units 3, 4, 5 are high-scoring

---

If you want next:

✔️ Answers for each question

✔️ Most expected 20 questions

✔️ One-day / three-day revision plan

✔️ PDF question bank

Just tell me 👍