10 Most Critical Questions to Practice

Section A (Long Questions)

Question 1: DBMS Architecture

What is DBMS? Define architecture of DBMS and explain its advantages and disadvantages.

Approach:

• Define DBMS as software for creating and managing databases
• Explain three-tier architecture (presentation, application, database layers)
• Discuss client-server model with diagram
• List 5 advantages (data independence, security, integrity, concurrent access, etc.)
• List 3 disadvantages (cost, complexity, performance overhead)

Question 2: Normalization

What is Normalization? List out the Normalization forms and explain 3NF in detail.

Approach:

• Define normalization as process to eliminate redundancy and anomalies
• List all normal forms (1NF through BCNF) with brief definitions
• For 3NF: Define completely (relation in 2NF with no transitive dependencies)
• Show example of relation moving from 2NF to 3NF
• Explain benefits of 3NF implementation

Question 3: Triggers

Explain Trigger with its syntax in detail. Include types of triggers with examples.