Civil Aviation Authority of Nepal2077 BSQuestion 11 of 18
Briefly describe the different data types used in the Database Management System.
5 marks
Question source
- Exam year
- 2077 BS / 2021 AD
- Level
- Level 5 (Prabidhik, IT, Barishtha Sahayak)
- Paper
- Paper II – Sewa Sambandhi
- Section
- Section B
Model answer
Data types fix allowed values and storage. Consistent with ASI/SI terminology:
- Text — Names/addresses (
Sita); Short ≤255, Long for remarks. - Number — Age, quantity; Byte/Integer/Long/Double by range.
- Currency — Salary as Rs. 45,000.00.
- Date/Time —
2024-01-15; enables age/duration math. - Yes/No — Checkbox (Present/Absent).
- AutoNumber — Auto ID, ideal PK.
- Attachment/OLE — Scanned PDFs/photos.
Correct choice prevents errors: Marks = Number (0–100 rule), fee = Currency.