WORTHY LEARNING LLC
brilliance with great character
Q1 – Math 9
Name: _______________________________________________________________________________
Date: __________________________ Score: ____________________
Section A: Multiple Choice Questions (1–10)
Choose the correct option.
1. What is the primary purpose of a database?
a) To draw charts
b) To store and manage data efficiently ✅
c) To send emails
d) To browse the internet
2. A Primary Key must:
a) Be duplicated
b) Be NULL
c) Uniquely identify each record ✅
d) Be a foreign key
3. Which of the following can act as a Candidate Key?
a) A column with duplicate values
b) A column that contains NULLs
c) Any column or combination of columns that uniquely identify a record ✅
d) A column used for totals
4. What is an Alternate Key?
a) A key used in alternate rows
b) A backup copy of a primary key
c) A candidate key not chosen as the primary key ✅
d) A field used only in reports
5. A Foreign Key in a relational database is used to:
a) Store external files
b) Maintain relationships between tables ✅
c) Generate reports
d) Create user logins
6. Which MS Access data type is best suited for long descriptive paragraphs?
a) Short Text
b) Number
c) Long Text ✅
d) Yes/No
7. What ensures referential integrity between two related tables?
a) Primary key alone
b) Indexing
c) Foreign key referencing the primary key ✅
d) Using only one table
8. In MS Access, which of the following data types is used for storing monetary
values?
a) Date/Time
b) Currency ✅
c) Yes/No
d) Number
9. What is the maximum length of data in a Short Text field in MS Access?
a) 50 characters
b) 100 characters
Page 1 of 3
c) 255 characters ✅
d) Unlimited
10. Which component of a database allows user-friendly data entry?
a) Query
b) Report
c) Form ✅
d) Macro
✳️Section B: Fill in the Blanks (11–15)
11. A __________ key is used to maintain referential integrity by linking two
related tables.
✅ Foreign
12. An __________ key is a candidate key that was not selected as the primary
key.
✅ Alternate
13. In database normalization, assigning a field with repeating values to a
new table improves __________.
✅ Data integrity (or data organization/normalization)
14. In MS Access, the __________ data type is used to store Boolean
(True/False) values.
✅ Yes/No
15. The __________ component in MS Access is used to extract and display
data based on specific criteria.
✅ Query
✳️Section C: Matching (16–20)
Match the MS Access data types with their descriptions:
Data Type Use Case Description
A. Currency 4. Stores monetary values with accuracy
B. Yes/No 1. Used to store true/false values
C. Short
3. Stores names, labels, or brief text entries
Text
D. Long 2. Suitable for long pieces of text or
Text paragraphs
E.
5. Stores calendar values like birth dates
Date/Time
Answers:
A→4✅
B→1✅
C→3✅
D→2✅
E→5✅
✳️Section D: Short Answer Questions (21–23)
21. Differentiate between Primary Key and Candidate Key.
✅ Answer:
A Primary Key uniquely identifies each record in a table and is chosen from among
the candidate keys. A Candidate Key is any field or combination of fields that could
serve as a unique identifier. There can be multiple candidate keys, but only one is
selected as the primary key.
22. What are the key components of a database system? List at least
four.
Page 2 of 3
✅ Answer:
1. Tables – Store data in rows and columns.
2. Queries – Retrieve and filter data.
3. Forms – Used for data entry and user interaction.
4. Reports – Generate printable summaries of data.
(Additional: Macros and Modules for automation and logic.)
23. Why is a foreign key important in relational databases?
✅ Answer:
A foreign key establishes a relationship between two tables and ensures referential
integrity, meaning only valid data that exists in the referenced (primary) table can
be inserted in the related table.
✳️Section E: Application/Scenario-Based Questions (24–25)
24. Scenario:
A Students table has columns: StudentID, Email, PhoneNumber.
Which of these columns could be Candidate Keys? If Email is chosen as the
Primary Key, what happens to the others?
✅ Answer:
All three fields could be candidate keys if they uniquely identify students. If Email is
chosen as the Primary Key, the others (e.g., StudentID, PhoneNumber) become
Alternate Keys, assuming they are also unique.
25. Write a real-world example of using a Foreign Key.
✅ Answer:
In a school database:
Students(StudentID, Name)
Grades(GradeID, StudentID, Subject, Score)
Here, StudentID in the Grades table is a foreign key that references the
Students table, linking each grade to the correct student.
Page 3 of 3