PYQ (English)

📘 DBMS PYQ – Last 13 Years (Trend-Based Questions)

🔹 1–2 Marks (Very Short Answer)

1. What is DBMS?

2. Difference between File System and DBMS.

3. What is Data Independence?

4. Difference between Schema and Instance.

5. Define Primary Key.

6. What is a Foreign Key?

7. Define Candidate Key.

8. What is a Super Key?

9. What is an Entity?

10. What is an Attribute?

11. What is a Constraint?

12. What is NULL value?

13. Difference between Tuple and Relation.

14. Define Degree and Cardinality.

🔹 3–4 Marks (Short Answer Questions)

1. Explain Primary Key and Foreign Key.

2. Explain Strong Entity Set and Weak Entity Set.

3. Explain different types of Constraints in DBMS.

4. Difference between Candidate Key and Primary Key.

5. What is Referential Integrity?

6. Explain ER Diagram with symbols.

7. What is a Composite Key? Give an example.

8. Explain types of Data Models.

9. Explain the Relational Model.

10. What is Normalization?

🔹 5–6 Marks (Long Answer Questions)

1. Explain advantages and disadvantages of DBMS.

2. Explain ER Model with an example.

3. What is Normalization? Explain 1NF and 2NF.

4. Explain Primary, Candidate, Foreign and Composite Keys.

5. Differentiate between Strong Entity Set and Weak Entity Set.

6. What are Constraints? Explain all types.

7. Explain limitations of File System.

8. Explain DBMS Architecture (1-tier, 2-tier, 3-tier).

🔹 8–10 Marks (Very Long / Essay Type Questions)

1. Explain Normalization with examples (1NF, 2NF, 3NF).

2. Explain ER Model in detail with diagram.

3. Differentiate between DBMS and RDBMS.

4. Explain all types of Keys with examples.

5. Explain components of a Database System.

⭐ Top 10 Most Repeated DBMS Questions (13-Year Analysis)

1. Primary Key vs Foreign Key

2. Strong Entity Set vs Weak Entity Set

3. Normalization (1NF, 2NF, 3NF)

4. ER Diagram and Symbols

5. Types of Keys in DBMS

6. Constraints in DBMS

7. DBMS vs File System

8. Data Independence

9. Relational Model

10. Candidate Key vs Super Key