Database Management (Level 2 & 3) – Past Questions & Answers
Complete guide to Database Management Level 2 past questions. Click on any question to reveal the answer.
Database Management (Level 2 & 3) – November/December 2015
Subject: Database Management
Examination Level: Level 2 & 3
This article contains the complete theory answers for Section A, a step-by-step explanation of Section B (Practical), a practical video lesson, and a downloadable PDF of the past questions. How to Use This Page: Click on any question below to reveal the answer. Watch the complete practical video for Section B.
Whether you're a student preparing for your exams or an instructor looking for reference material, this guide will help you understand the concepts and improve your practical database skills.
SECTION A – Theory Questions & Answers
Question 1: Explain DBMS.
A Database Management System (DBMS) is software that enables users to create, store, organize, retrieve, update, and manage data in a database efficiently.
Examples include:
- Microsoft Access
- MySQL
- Oracle Database
- SQL Server
Question 2: Describe the term Table under Database.
A Table is a database object that stores related information in rows (records) and columns (fields). Every database consists of one or more tables.
Question 3: Define Query.
A Query is a database object used to retrieve, search, sort, filter, calculate or modify data stored in one or more tables.
Question 4: Explain the purpose of Forms in a Database.
Forms provide an easy and user-friendly interface for entering, editing, viewing and managing records stored in a database.
Question 5: Explain the term Report.
A Report is a formatted presentation of data from a table or query. Reports are mainly used for printing and summarizing information.
Question 6: Describe a Dialog Box.
A Dialog Box is a small window that appears on the screen to request user input or provide information, warnings or options.
Question 7: Explain Datasheet View.
Datasheet View displays database records in rows and columns. It allows users to add, edit, delete and view records directly.
Question 8: Differentiate between Append Query and Delete Query.
| Append Query | Delete Query |
|---|---|
| Adds records from one table to another table. | Permanently removes records from a table. |
Question 9: Describe Secondary Sort Key.
A Secondary Sort Key is an additional field used to sort records whenever two or more records have identical values in the primary sort field.
Question 10: Describe Database Object.
Database objects are components used to create and manage databases. Examples include:
- Tables
- Queries
- Forms
- Reports
- Macros
- Modules
SECTION B – Practical Question
Practical Task
Create the following table in Microsoft Access.
| Employee ID | Pay Rate | Hours Worked |
|---|---|---|
| 015 | 12.50 | 35 |
| 131 | 10.50 | 50 |
| 139 | 3.75 | 40 |
| 216 | 8.65 | 30 |
| 245 | 10.65 | 45 |
| 260 | 12.45 | 60 |
| 275 | 10.50 | 75 |
Required Query Calculations
- Gross Pay:
[Pay Rate] * [Hours Worked] - Tax (10%):
[Gross Pay] * 0.10 - Net Pay:
[Gross Pay] - [Tax]
Expected Output
| Employee ID | Gross Pay | Tax | Net Pay |
|---|---|---|---|
| 015 | 437.50 | 43.75 | 393.75 |
| 131 | 525.00 | 52.50 | 472.50 |
| 139 | 150.00 | 15.00 | 135.00 |
| 216 | 259.50 | 25.95 | 233.55 |
| 245 | 479.25 | 47.93 | 431.32 |
| 260 | 747.00 | 74.70 | 672.30 |
| 275 | 787.50 | 78.75 | 708.75 |
Practical Video Lesson
Watch the complete Microsoft Access practical tutorial for Section B below.
Download Past Question
Want the original examination paper? Click the button below.
Before Your Download Begins...
To support the creation of more free solved past questions and practical lessons, kindly subscribe first.
Get access to:
- Solved Past Questions
- Practical Video Tutorials
- Microsoft Access Lessons
- Database Management Notes
Subscribe to our YouTube Channel
Click the button below to subscribe – your download will start automatically after subscription.
Join Our Tech Family
Get new lessons, tech tips, and updates directly on your phone. Be part of our growing IT community, never miss a tutorial or Windows tip!
World Class IT Solutions Across the Globe.
Empowering Businesses, Students & Organizations with World Class IT Solutions Across the Globe.
USA
UK
Canada
Australia
Germany
France
India
Nigeria
Ghana
Kenya
South Africa
Brazil
Mexico
Japan
China
Russia USA UK Canada Australia Germany France India Nigeria Ghana Kenya South Africa Brazil Mexico Japan China RussiaOur Other Plans
Explore our professional services tailored to meet your business needs. Click "Get a Quote" to start a conversation on WhatsApp.
Front-End Development
Responsive UIs, interactive components, modern frameworks & performance.
Get a QuoteOur Services Membership Plans
Get instant access to the full script library — activate online in minutes, no waiting. Choose the plan that fits your needs and unlock premium resources, source code, and commercial licenses.
VIP MEMBERSHIP
One Plan. Every Script. Full Source Code.
Instead of buying scripts one by one, get access to everything — every template and source code we have built, plus everything we ship in the future. One plan, no restrictions.
- Full Script Library
- Complete Source Code
- Future Scripts Included
- 6 Months Direct Support
PHP + Apps Script
- Full Access — PHP & Apps Script projects
- Step-by-step video guides
- Commercial-use license
- AI Prompts included — Free
- Ready-to-use projects
- Bug fixes & free future updates
- Future video releases auto added
- Installation help included
- No recurring charges
- 1 downloads/day
- Full source code access
- Files you download stay yours for lifetime
- Resale rights included
- Modification rights included
- 24/7 WhatsApp support
PHP + Apps Script
- Full Access — PHP & Apps Script projects
- Step-by-step video guides
- Commercial-use license
- AI Prompts included — Free
- Ready-to-use projects
- Bug fixes & free future updates
- Future video releases auto added
- Installation help included
- No recurring charges
- 2 downloads/day
- Full source code access
- Files you download stay yours for lifetime
- Resale rights included
- Modification rights included
- 24/7 WhatsApp support
PHP + Apps Script
- Full Access — PHP & Apps Script projects
- Step-by-step video guides
- Commercial-use license
- AI Prompts included — Free
- Ready-to-use projects
- Bug fixes & free future updates
- Future video releases auto added
- Installation help included
- No recurring charges
- 3 downloads/day
- Full source code access
- Files you download stay yours for lifetime
- Resale rights included
- Modification rights included
- 24/7 WhatsApp support
Languages & Technologies We Work With
Core competencies and the business problems each one solves. From automation to full-stack solutions, these tools power our services.
