Computer Science
Secondary 2
Semester 2
A. Multiple Choices
Direction: In this section you will see option a, b, c, and d. Answer the question with
the best answer by give mark X to the appropriate option in your answer sheet!
1. Which statement best describes a data model?
a. a digital data representation of a real-life scenario
b. a computer program that represent a real-life scenario using formulae and
can be used to predict outcomes
c. an application that uses rows and columns to organise data and carry out
calculations
d. an application that is used to organise data than can then be stored,
processed and accessed
2. A company uses a computer program to test how traffic moves in a city before
building new roads. This is an example of …
a. Animation
b. Data entry
c. Simulation
d. Spreadsheet processing
3. Why are simulations often safer than real-life testing?
a. They never use computers
b. They reduce risks, costs, and possible accidents
c. They always produce perfect results
d. They only use paper-based systems
4. A student database contains many students with the same first name. Which
field would be the MOST reliable primary key?
a. Age
b. Class Name
c. Student ID
d. Favourite Subject
5. A hospital needs to manage patient records, doctor information, and
appointments. Which application would be MOST appropriate?
a. Presentation software
b. Spreadsheet software only
c. Database software such as Microsoft Access
d. Drawing software
6. Which data type is MOST suitable for storing a student’s exam score?
a. Text
b. Number
c. Hyperlink
d. Memo
7. The data type that can be use to store money value in different currency format
such as Dollar or EGP is …
a. Number
b. Text
c. Autonumber
d. Currency
8. A school stores students’ birthdays in a database. Which data type should be
used?
a. Date/Time
b. Currency
c. Text
d. AutoNumber
9. A school uses an online registration form where students enter their name,
class, date of birth, and phone number. What is the MAIN purpose of this data
capture form?
a. To decorate the database with colors and images
b. To collect and store user information accurately into the system
c. To automatically delete old student records
d. To create graphs and charts only
10. Which of the following is MOST likely considered a data item in a hospital
database?
a. Patient ID Number
b. Keyboard
c. Wi-Fi Router
d. Computer Screen
11. What is the main purpose of data validation in a database system?
a. Provide the user with list of options to choose from when entering data under
a particular field heading in database
b. Set type of data that is being stored
c. The number of characters a field in database application allows to be stored
d. An automatic check to reduce the chance of errors being made when data is
entered
12. A data structure where the data items are broken down into the smallest
unit possible is …
a. Primary key
b. Data dictionary
c. Lookup
d. Atomic data structure
Look at this following database to answer question number 13-15.
13. Which field is the BEST choice for the primary key in the table?
a. NAME
b. CLASS
c. ID
d. GENDER
14. A teacher wants to make sure students only enter marks between 0 and
100. Which validation check should be used?
a. Presence check
b. Range check
c. Length check
d. Format check
15. Which data type is MOST suitable for the “MARK” field?
a. Text
b. Number
c. Date/Time
d. Boolean
16. An online form requires users to enter their age between 13 and 18 years
old. Which validation method should be used?
a. Presence check
b. Range check
c. Length check
d. Lookup check
17. A registration form shows an error message because the “Name” field is
empty. Which validation rule caused this?
a. Range check
b. Length check
c. Presence check
d. Type check
18. A school needs to store student records, attendance, exam scores, and
teacher information in related tables. Which software is MOST suitable?
a. Microsoft Excel, because it is best for relational databases
b. Microsoft Access, because it can manage related tables and large amounts of
data
c. Microsoft Word, because it can create charts
d. Microsoft Paint, because it can organize records
19. A school wants to create a student database system. Which of the
following is MOST important as a data requirement?
a. The database should store accurate and complete student information
b. The database should contain colorful backgrounds
c. The database should play music automatically
d. The database should include animation effects
20. A company is planning a new employee database. Why should they
identify data requirements first?
a. To know what information needs to be collected and managed
b. To make the database heavier
c. To reduce the monitor size
d. To install more speakers
B. Essay
Direction: Answers the question with correct answer on your answer sheet!
1. Decide the validation check for each situation:
a. An email address must contain “@[Link]” ______________________
b. A password must contain exactly 8 characters ______________________
c. A student’s test score must be between 0 and 100 ______________________
d. A user cannot leave the “Full Name” field empty ______________________
e. A student enters letters in the “Age” field, but only numbers are allowed
______________________
2. A pilot uses a flight simulator before flying a real airplane. Explain why
simulations are useful for training and learning.
3. A school wants to create a database system to manage:
Students
Teachers
Subjects
Exam Results
a. How many tables are needed?
b. Suggest one suitable primary key for each table.
c. Explain why primary keys are important.
4. Compare Microsoft Access and Microsoft Excel. Write at least three differences
between the two applications.
5. An online competition registration form asks users to enter:
Full Name
Age
Email Address
Phone Number
Create your own data based!