National Tea and Coffee Development Board2078 BSQuestion 3 of 5
What is DBMS? Explain advantages and disadvantages of DBMS.
10 marks
Question source
- Exam year
- 2078 BS / 2021 AD
- Level
- Assistant First Level (Computer Operator)
- Paper
- Section B – Subjective
- Section
- Section B: Subjective
Model answer
A DBMS (MySQL, MS-Access) manages databases centrally with queries, security and recovery — e.g. Board's tea-garden registry instead of scattered Excels.
Advantages:
- Less redundancy — Farmer stored once, reused.
- Integrity — Validation + referential rules block wrong entries.
- Sharing + security — Concurrent roles with logs.
- Fast queries/reports — "List Ilam gardens >10 ropani" in seconds.
- Backup/recovery — Restore after failure.
Disadvantages:
- Cost/complexity — License + trained DBA needed.
- Overhead — Slower than flat file for tiny single-user lists.
- Failure impact — Central crash halts all unless replicated; needs regular backup and access control.
Use DBMS when records grow and sharing matters; flat files suffice for one-off small lists.