SS3 Second Term Data Processing Past Questions And Answers

 

Senior Secondary School 3 Second Term Data Processing questions with options and answers:

 

Question: What is the primary purpose of a database index?

 

A) Enhance data security

B) Speed up data retrieval

C) Perform complex calculations

D) Store large files

Answer: B) Speed up data retrieval

Question: Which data processing operation involves combining two or more tables based on a common field?

 

A) Sorting

B) Merging

C) Filtering

D) Indexing

Answer: B) Merging

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

 

A) Provide a unique identifier for each record

B) Establish a link between tables

C) Perform mathematical operations

D) Store multimedia files

Answer: B) Establish a link between tables

Question: In a spreadsheet, what function is used to find the highest value in a range of cells?

 

A) MAX

B) MIN

C) AVG

D) SUM

Answer: A) MAX

Question: Which data structure is suitable for storing and retrieving data in a last-in, first-out manner?

 

A) Stack

B) Queue

C) Linked List

D) Binary Search Tree

Answer: A) Stack

Question: What is the significance of the “JOIN” operation in a SQL query?

 

A) Filter data based on a condition

B) Combine rows from different tables

C) Sort results in ascending order

D) Remove duplicate entries

Answer: B) Combine rows from different tables

Question: Which data processing technique involves predicting future values based on historical data?

 

A) Clustering

B) Regression

C) Sampling

D) Interpolation

Answer: B) Regression

Question: What is the purpose of data validation in a database?

 

A) Ensure data accuracy and consistency

B) Speed up data entry

C) Encrypt sensitive information

D) Generate random data

Answer: A) Ensure data accuracy and consistency

Question: In the context of databases, what does CRUD stand for?

 

A) Create, Read, Update, Delete

B) Compute, Record, Utilize, Duplicate

C) Copy, Rename, Update, Download

D) Connect, Retrieve, Upload, Delete

Answer: A) Create, Read, Update, Delete

Question: Which type of software is designed to protect a computer system from malicious software and security threats?

 

A) Database Management System (DBMS)

B) Operating System

C) Antivirus

D) Spreadsheet Software

Answer: C) Antivirus

Question: What is the purpose of a data warehouse in business intelligence?

 

A) Speed up data entry

B) Store historical and current data for analysis

C) Create pivot tables

D) Design graphical user interfaces

Answer: B) Store historical and current data for analysis

Question: Which data processing operation involves removing unnecessary data from a dataset?

 

A) Sorting

B) Filtering

C) Merging

D) Indexing

Answer: B) Filtering

Question: What is the role of a cache in computer systems?

 

A) Store permanent data

B) Speed up data retrieval by storing frequently accessed data

C) Manage network connections

D) Encrypt data transmission

Answer: B) Speed up data retrieval by storing frequently accessed data

Question: In a network, what is the purpose of an IP address?

 

A) Identify a specific computer on the internet

B) Manage file storage

C) Execute program instructions

D) Control access to a database

Answer: A) Identify a specific computer on the internet

Question: Which type of database model uses tables to organize data?

 

A) Hierarchical

B) Network

C) Relational

D) Object-Oriented

Answer: C) Relational

Question: What is the purpose of data mining in the context of databases?

 

A) Store large files

B) Analyze and discover patterns in large datasets

C) Speed up data entry

D) Generate random data

Answer: B) Analyze and discover patterns in large datasets

Question: What is the primary purpose of a firewall in network security?

 

A) Encrypt data

B) Monitor network traffic

C) Block unauthorized access

D) Increase internet speed

Answer: C) Block unauthorized access

Question: Which data processing technique involves estimating missing values in a dataset?

 

A) Clustering

B) Sampling

C) Regression

D) Interpolation

Answer: D) Interpolation

Question: What is the purpose of a computer virus?

 

A) Enhance system performance

B) Speed up data processing

C) Cause harm and replicate itself

D) Improve network security

Answer: C) Cause harm and replicate itself

Question: In a relational database, what is the purpose of the “ALTER TABLE” statement?

 

A) Add a new record

B) Modify the structure of a table

C) Delete all records

D) Retrieve specific data

Answer: B) Modify the structure of a table.