SS2 Digital Technology Examination Questions (Objective and Theory)
SS2 Digital Technology Examination Questions (Objective and Theory)
We have provided these SS2 Digital Technology examination questions to help teachers prepare school examinations, class tests, assignments, and revision exercises for students. The questions are based on topics covered in the Digital Technology scheme of work and can be used as teaching and assessment resources.
This collection contains 30 objective questions and 4 theory questions covering important topics such as database concepts, Database Management Systems (DBMS), database security, database administration, data models, relational databases, database normalization, Entity-Relationship Diagrams (ERD), and logic gates.
Teachers can use these questions to assess students’ understanding, prepare examination papers, or provide additional classroom exercises. Students can also use them for revision and examination practice to improve their knowledge of Digital Technology.
These questions are suitable for Senior Secondary School 2 (SS2) Digital Technology students and can also serve as reference or practice materials for teachers, schools, and other educational institutions.
Examination Structure:
- Subject: Digital Technology
- Class: SS2
- Section A: 30 Objective Questions (30 Marks)
- Section B: Theory Questions (Answer Any 3)
- Total: 70 Marks as allocated in the examination sections
Note to Teachers: These questions are provided as educational resources. You may adapt them to suit your school’s examination format and the topics covered in your classroom.
DIGITAL TECHNOLOGY EXAMINATION QUESTIONS
SS2
Name: ______________________________ Â Class: __________ Â Date: __________
Time Allowed: __________________
SECTION A: OBJECTIVE QUESTIONS (30 MARKS)
Instruction: Answer ALL questions. Choose the correct option from A to D. Each question carries 1 mark.
- What is a database?
(A) A collection of computer programs  (B) An organized collection of related data  (C) A collection of computer hardware  (D) A set of instructions for starting a computer - What is the full meaning of DBMS?
(A) Digital Base Management Software  (B) Data Backup Monitoring System  (C) Database Management System  (D) Database Machine Service - Which of the following best describes a Database Management System?
(A) Software used to create and manage databases  (B) Software used only to type documents  (C) Hardware used to store computer files  (D) A device used to connect computers to electricity - Which of the following is an example of a DBMS?
(A) Microsoft Word  (B) Microsoft Paint  (C) Microsoft PowerPoint  (D) Microsoft Access - Which of the following is a major purpose of a DBMS?
(A) To increase the number of duplicate records  (B) To organize and manage data efficiently  (C) To prevent users from retrieving stored data  (D) To replace the computer’s operating system - Which of the following is an advantage of using a DBMS?
(A) It makes data unnecessarily difficult to access  (B) It encourages uncontrolled data duplication  (C) It improves data security and organization  (D) It prevents users from updating records - Which of the following is another example of database management software?
(A) MySQL  (B) Microsoft Paint  (C) Windows Media Player  (D) Microsoft PowerPoint - Which of the following is a function of a DBMS?
(A) Designing computer processors  (B) Producing electricity for computers  (C) Repairing damaged computer keyboards  (D) Storing, retrieving, and updating data - What is data redundancy?
(A) The protection of data against unauthorized access  (B) The unnecessary duplication of the same data  (C) The conversion of data into meaningful information  (D) The removal of incorrect data from a database - Which DBMS feature helps prevent unauthorized users from accessing confidential records?
(A) Data sorting  (B) Data duplication  (C) Access control  (D) Data formatting - What does data integrity mean?
(A) Maintaining the accuracy and consistency of data  (B) Increasing the number of records in a database  (C) Making every user an administrator  (D) Storing all records in a single table - Which language is commonly used to retrieve and manipulate data in a relational database?
(A) HTML Â (B) SQL Â (C) CSS Â (D) XML - Which of the following is a relational database management system?
(A) Adobe Photoshop  (B) Microsoft Word  (C) VLC Media Player  (D) MySQL - What is a database query?
(A) A device used to store database files  (B) A program used only for drawing tables  (C) A request to retrieve or manipulate data  (D) A command used only to shut down a computer - Database management involves ______.
(A) Designing and manufacturing computer hardware  (B) Organizing, storing, updating, and maintaining data  (C) Connecting computers to a power supply  (D) Preparing documents without storing information - Who is primarily responsible for managing and maintaining an organization’s database system?
(A) Database Administrator  (B) Computer Operator  (C) Graphic Designer  (D) Data Entry Clerk - Which of the following is a responsibility of a Database Administrator (DBA)?
(A) Designing posters for the organization  (B) Preparing handwritten examination questions  (C) Managing database security and backups  (D) Repairing all electrical appliances in the office - Why is it important to back up a database?
(A) To increase the size of every database table  (B) To make stored information available to unauthorized users  (C) To remove all duplicate records automatically  (D) To recover data if the original is lost or damaged - Which of the following is the best way to protect confidential database records?
(A) Allowing everyone to use the same password  (B) Giving users access according to their permissions  (C) Sharing administrator passwords with all staff  (D) Disabling the database security system - Which of the following is an example of database maintenance?
(A) Checking database performance and updating database software  (B) Deleting all records after every working day  (C) Allowing unauthorized users to change records  (D) Removing all backup copies of important data - What is a data model?
(A) A computer program used only for typing  (B) A physical device used for storing information  (C) A representation of how data is organized and related  (D) A method of connecting computers to a network - Which data model organizes data into tables made up of rows and columns?
(A) Hierarchical model  (B) Network model  (C) Object-oriented model  (D) Relational model - Which data model organizes records in a tree-like structure?
(A) Relational model  (B) Hierarchical model  (C) Network model  (D) Object-oriented model - Which data model allows a record to have multiple parent records?
(A) Hierarchical model  (B) Relational model  (C) Network model  (D) Flat-file model - In a relational database, data is organized mainly into ______.
(A) Tables  (B) Slides  (C) Paragraphs  (D) Pictures - In a relational database table, a row is commonly called a ______.
(A) Field  (B) Attribute  (C) Column  (D) Record - In a database table containing students’ names, ages, and classes, each column represents a ______.
(A) Record  (B) Field or attribute  (C) Database file  (D) Complete transaction - Which key uniquely identifies each record in a database table?
(A) Foreign key  (B) Duplicate key  (C) Primary key  (D) Repeating key - What is data modeling?
(A) The process of designing a structure for data and its relationships  (B) The process of deleting all records from a database  (C) The process of converting a computer into a printer  (D) The process of entering data without organizing it - Which diagram is commonly used to show entities and relationships in a database?
(A) Bar chart  (B) Pie chart  (C) Flowchart  (D) Entity-Relationship Diagram (ERD)
SECTION B: THEORY QUESTIONS (40 MARKS)
Instruction: Answer any 3 questions. Each question carries 10 marks.
1. Database and Database Security
(a) What is a database? [2 marks]
(b) What is database security? [2 marks]
(c) State three ways of protecting the records in a database. [3 marks]
(d) State three responsibilities of a Database Administrator (DBA). [3 marks]
2. Database Normalization
(a) What is database normalization? [2 marks]
(b) State two reasons for normalizing a database. [2 marks]
(c) Explain briefly each of the following:
- (i) First Normal Form (1NF)
- (ii) Second Normal Form (2NF)
- (iii) Third Normal Form (3NF)
[6 marks]
3. Database Structure and Entity-Relationship Diagram
(a) Define each of the following in a database:
- (i) Table
- (ii) Field
- (iii) Record
[3 marks]
(b) Define the following and give one example of each from a school database:
- (i) Entity
- (ii) Attribute
[4 marks]
(c) What is a primary key? [1 mark]
(d) What is an Entity-Relationship Diagram (ERD)? [2 marks]
4. Logic Gates
(a) What is a logic gate? [2 marks]
(b) State the two binary values used by logic gates and what each one means. [2 marks]
(c) Draw the symbol of the AND gate, write its Boolean expression and complete its truth table. [3 marks]
(d) Draw the symbol of the NOT gate and write its truth table. [3 marks]
END OF EXAMINATION
We hope these SS2 Digital Technology objective and theory questions are useful for teachers, students, classroom assessments, revision, and examination preparation.

