PYQ (English)

📘 DBMS 

2017

• Define Data, Database, DBMS.

• Difference between File System and DBMS.

• List applications of DBMS.

• Explain data abstraction with diagram.

• What is data independence and its types?

• Define schema and instance.

• Explain two-tier architecture.

• Explain three-tier architecture with diagram.
  (Repeated in many diploma questions of 2017-2018 types)

2018

(Similar pattern as 2017 because polytechnic DBMS course maintained basic concepts in earlier years)

• Explain data models and list their types.

• Give difference between hierarchical and network data models.

• Give difference between relational and network model.

• Give difference between relational and hierarchical model.
  (Topics often appear year after year as PVQs)

2019

• Define DBMS and explain advantages over file system.

• Explain three-level DBMS architecture.

• What are DBMS languages (DDL, DML, DCL)?

• Explain Codd’s rules (important for relational model).
  (Found in diploma DBMS RGPV style past papers and question banks)

2020–2024

(Pattern continues in polytechnic question banks even if specific PDF not indexed online)

• What is data model? Give types.

• Explain advantages of DBMS with examples.

• Describe three levels of data abstraction.

• Define instance and schema.

• What is data independence and why needed?
  (These are staple PVQs from Unit/Chapter 1 of DBMS and appear repeatedly in question banks and exam papers)

📗 Typical Exam / Viva Questions (Chapter 1 DBMS)

These are common PVQs across multiple years in polytechnic diploma exams:

1. Define Database and DBMS.

2. Difference between File Processing System & DBMS.

3. Explain data abstraction with levels.

4. What is data independence? Name its types.

5. Define schema & instance.

6. Explain DBMS architecture (two-tier & three-tier).

7. List types of data models.

8. Difference between hierarchical, network & relational models.

9. Explain Codd’s rules (important for question paper).