SS2 Third Term Data Processing Past Questions And Answers

 

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

 

Question: What is the primary purpose of data normalization in a relational database?

 

a) Increase data redundancy

b) Simplify data storage

c) Ensure data preservation

d) Delete unnecessary records

 

Answer: b) Simplify data storage

 

Question: In a flowchart, what symbol is used to represent a decision or branching point?

 

a) Oval

b) Rectangle

c) Diamond

d) Parallelogram

 

Answer: c) Diamond

 

Question: Which of the following is a characteristic of a good database design?

 

a) Maximum redundancy

b) Minimum data integrity

c) Efficient data retrieval

d) Uncontrolled data access

 

Answer: c) Efficient data retrieval

 

Question: What does the acronym CRUD stand for in database management?

 

a) Create, Retrieve, Update, Delete

b) Computer, Result, Upload, Download

c) Calculate, Record, Understand, Define

d) Control, Read, Unify, Deploy

 

Answer: a) Create, Retrieve, Update, Delete

 

Question: Which type of join in SQL returns only the common rows between two tables?

 

a) Inner Join

b) Outer Join

c) Left Join

d) Cross Join

 

Answer: a) Inner Join

 

Question: What is the role of an index in a database table?

 

a) Encrypt data

b) Sort data alphabetically

c) Accelerate data retrieval

d) Delete records

 

Answer: c) Accelerate data retrieval

 

Question: In programming, what does the term “scope” refer to?

 

a) The size of a program file

b) The range of visibility of a variable

c) The speed of program execution

d) The style of coding

 

Answer: b) The range of visibility of a variable

 

Question: Which file format is commonly used for storing structured data in a tabular form?

 

a) TXT

b) PDF

c) CSV

d) HTML

 

Answer: c) CSV

 

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

 

a) Ensure data uniqueness

b) Define the primary key

c) Establish relationships between tables

d) Encrypt data

 

Answer: c) Establish relationships between tables

 

Question: Which of the following is a disadvantage of using a hash function for data encryption?

 

a) High security

b) Irreversibility

c) Fast data retrieval

d) Limited collision possibility

 

Answer: b) Irreversibility

 

Question: What is the primary role of an ERD (Entity Relationship Diagram) in database design?

 

a) Define data types

b) Represent relationships between entities

c) Create tables

d) Write SQL queries

 

Answer: b) Represent relationships between entities

 

Question: In a spreadsheet, what function does the formula “=COUNT(A1:A10)” perform?

 

a) Sum the values in A1 to A10

b) Find the average of values in A1 to A10

c) Count the number of cells with values in A1 to A10

d) Multiply the values in A1 to A10

 

Answer: c) Count the number of cells with values in A1 to A10

 

Question: Which database model allows the storage of data in a network-like structure?

 

a) Relational

b) Hierarchical

c) Object-Oriented

d) NoSQL

 

Answer: c) Object-Oriented

 

Question: What does the term “big data” refer to in the context of data processing?

 

a) Small-sized datasets

b) Extremely fast data retrieval

c) Large and complex datasets

d) Highly encrypted datasets

 

Answer: c) Large and complex datasets

 

Question: In networking, what is the purpose of a subnet mask?

 

a) Identify the network portion of an IP address

b) Encrypt data transmission

c) Determine the speed of the internet connection

d) Block unauthorized access

 

Answer: a) Identify the network portion of an IP address

 

Question: Which programming language is commonly used for statistical analysis and data visualization?

 

a) Java

b) Python

c) C++

d) Ruby

 

Answer: b) Python

 

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

 

a) Manage day-to-day transactions

b) Store and analyze historical data

c) Provide real-time data access

d) Encrypt sensitive data

 

Answer: b) Store and analyze historical data

 

Question: What is the purpose of the SELECT statement in SQL?

 

a) Insert new records

b) Update existing records

c) Retrieve data from a database

d) Delete records

 

Answer: c) Retrieve data from a database

 

Question: In web development, what does the term “responsive design” refer to?

 

a) Fast internet connection

b) Designing websites for mobile and desktop devices

c) Secure data transmission

d) Dynamic web content

 

Answer: b) Designing websites for mobile and desktop devices

 

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.