SS3 Third Term Data Processing Past Questions And Answers

 

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

 

Question: What is the purpose of data normalization in database design?

 

A) Increase redundancy

B) Simplify data retrieval

C) Decrease data integrity

D) Speed up data entry

Answer: B) Simplify data retrieval

Question: In a spreadsheet, what does the “VLOOKUP” function do?

 

A) Multiply values in a range

B) Search for a value in a vertical column

C) Count the number of cells in a range

D) Create a pie chart

Answer: B) Search for a value in a vertical column

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

 

A) Store backup data

B) Speed up data entry

C) Analyze and report on large datasets

D) Manage file storage

Answer: C) Analyze and report on large datasets

Question: In a relational database, what is the role of the “CASCADE” option in a foreign key constraint?

 

A) Restrict deletion of a parent record

B) Delete all related records automatically

C) Update the foreign key value

D) Add a new record to the child table

Answer: B) Delete all related records automatically

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

 

A) Sorting

B) Merging

C) Filtering

D) Indexing

Answer: B) Merging

Question: What is the purpose of data mining in the field of data processing?

 

A) Organize data in a structured manner

B) Analyze and discover patterns in large datasets

C) Remove duplicate entries in a database

D) Encrypt sensitive information

Answer: B) Analyze and discover patterns in large datasets

Question: In the context of database transactions, what does the term “Rollback” mean?

 

A) Save the changes to the database

B) Undo the changes made in the current transaction

C) Commit the transaction

D) Retrieve specific data

Answer: B) Undo the changes made in the current transaction

Question: Which data structure is used for efficient searching and retrieval in a sorted list?

 

A) Stack

B) Queue

C) Binary Search Tree

D) Linked List

Answer: C) Binary Search Tree

Question: What is the primary function of a data dictionary in a database system?

 

A) Store user passwords

B) Manage network connections

C) Define data elements and their characteristics

D) Display graphical representations of data

Answer: C) Define data elements and their characteristics

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 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 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 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

Question: Which encryption method is commonly used to secure data transmission over the internet?

 

A) ROT13

B) Caesar Cipher

C) AES (Advanced Encryption Standard)

D) DES (Data Encryption Standard)

Answer: C) AES (Advanced Encryption Standard)

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: 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 significance of the “HAVING” clause in a SQL query?

 

A) Filter data based on a condition

B) Sort results in ascending order

C) Group data for aggregation

D) Join tables together

Answer: C) Group data for aggregation

Question: Which type of graph is best suited for showing the distribution of a dataset?

 

A) Bar chart

B) Pie chart

C) Histogram

D) Line graph

Answer: C) Histogram

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

 

A) Atomicity, Consistency, Integrity, Durability

B) Analysis, Configuration, Implementation, Deployment

C) Access, Control, Identification, Detection

D) Allocation, Caching, Indexing, Duplication

Answer: A) Atomicity, Consistency, Integrity, Durability

Question: What is the purpose of a pivot table in Excel?

 

A) Perform complex calculations

B) Create charts and graphs

C) Summarize and analyze data

D) Insert images into a spreadsheet

Answer: C) Summarize and analyze data.