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.
