SS2 Second Term Data Processing Past Questions And Answers

 

Senior Secondary School 2 Second Term Data Processing Questions with options and answers:

 

Question: What is the primary purpose of data backup?

 

a) Increase data redundancy

b) Speed up data retrieval

c) Ensure data preservation

d) Delete unnecessary records

 

Answer: c) Ensure data preservation

 

Question: In a relational database, what does a foreign key establish?

 

a) Data redundancy

b) Link between tables

c) Data encryption

d) Data sorting

 

Answer: b) Link between tables

 

Question: What is the significance of a line chart in data representation?

 

a) Show trends over time

b) Display hierarchical relationships

c) Compare individual data points

d) Represent percentages

 

Answer: a) Show trends over time

 

Question: Which programming concept involves breaking down a problem into smaller, more manageable parts?

 

a) Abstraction

b) Inheritance

c) Encapsulation

d) Modularization

 

Answer: d) Modularization

 

Question: What does the term “HTTP” stand for in web development?

 

a) HyperText Transfer Protocol

b) High-Level Transfer Protocol

c) HyperLink and Text Protocol

d) Hypertext Transfer Program

 

Answer: a) HyperText Transfer Protocol

 

Question: In a spreadsheet, what function does VLOOKUP perform?

 

a) Vertical Lookup

b) Value Lookup

c) Variable Lookup

d) Vector Lookup

 

Answer: a) Vertical Lookup

 

Question: What is the purpose of a cache memory in a computer system?

 

a) Store permanent data

b) Increase RAM capacity

c) Speed up data access

d) Manage network connections

 

Answer: c) Speed up data access

 

Question: Which data structure uses Last In, First Out (LIFO) order?

 

a) Queue

b) Stack

c) Linked List

d) Tree

 

Answer: b) Stack

 

Question: What is the role of an interrupt in computer systems?

 

a) Manage printing tasks

b) Temporarily pause the execution of a program

c) Encrypt data

d) Create virtual networks

 

Answer: b) Temporarily pause the execution of a program

 

Question: Which of the following is an example of a front-end programming language?

 

a) Java

b) Python

c) HTML

d) SQL

 

Answer: c) HTML

 

Question: What is the purpose of a file extension in a computer file?

 

a) Identify the file type

b) Increase file size

c) Encrypt file content

d) Accelerate file access

 

Answer: a) Identify the file type

 

Question: In networking, what does the term “WAN” stand for?

 

a) Wireless Area Network

b) Wide Access Network

c) Wide Area Network

d) Wireless Access Network

 

Answer: c) Wide Area Network

 

Question: What is the primary function of an antivirus program?

 

a) Manage network connections

b) Encrypt data

c) Protect against malicious software

d) Speed up internet connection

 

Answer: c) Protect against malicious software

 

Question: Which database model represents data in a tree-like structure?

 

a) Relational

b) Hierarchical

c) Network

d) Object-Oriented

 

Answer: b) Hierarchical

 

Question: What does the acronym HTTPS stand for in web security?

 

a) HyperText Transfer Protocol Secure

b) High-Level Transfer Protocol Secure

c) HyperLink and Text Protocol Secure

d) Hypertext Transfer Program Secure

 

Answer: a) HyperText Transfer Protocol Secure

 

Question: In programming, what is the purpose of the “else” statement in an if-else construct?

 

a) Begin a loop

b) Execute a block of code if the condition is true

c) Provide an alternative action if the condition is false

d) End the program

 

Answer: c) Provide an alternative action if the condition is false

 

Question: What is the purpose of a foreign key in a relational database?

 

a) Ensure data uniqueness

b) Establish relationships between tables

c) Sort data alphabetically

d) Accelerate data retrieval

 

Answer: b) Establish relationships between tables

 

Question: Which type of software is designed to perform specific tasks for end-users?

 

a) System software

b) Application software

c) Database software

d) Network software

 

Answer: b) Application software

 

Question: What is the significance of the “404 Not Found” error in web browsing?

 

a) Slow internet connection

b) Server not responding

c) Page not available

d) Browser malfunction

 

Answer: c) Page not available

 

Question: What is the purpose of a switch in networking?

 

a) Provide internet access

b) Connect devices within the same network

c) Manage printer connections

d) Block unauthorized access

 

Answer: b) Connect devices within the same network.