SS2 First Term Data Processing Past Questions And Answers
Question: What is the primary function of a database management system (DBMS)?
a) Create spreadsheets
b) Manage and organize data
c) Design graphics
d) Browse the internet
Answer: b) Manage and organize data
Question: In a flowchart, what symbol is used to represent a process?
a) Rectangle
b) Diamond
c) Oval
d) Parallelogram
Answer: a) Rectangle
Question: What is the purpose of normalization in a relational database?
a) Add redundancy
b) Simplify data storage
c) Increase data complexity
d) Speed up data retrieval
Answer: b) Simplify data storage
Question: Which data type is suitable for storing decimal numbers in a programming language?
a) Integer
b) String
c) Float
d) Boolean
Answer: c) Float
Question: What is the function of the INDEX in a database table?
a) Sort data alphabetically
b) Accelerate data retrieval
c) Encrypt data
d) Delete records
Answer: b) Accelerate data retrieval
Question: Which of the following is an example of secondary storage?
a) RAM
b) Hard disk drive
c) CPU
d) Cache memory
Answer: b) Hard disk drive
Question: What is the purpose of a firewall in network security?
a) Manage data encryption
b) Block unauthorized access
c) Speed up internet connection
d) Create virtual networks
Answer: b) Block unauthorized access
Question: In a spreadsheet, what does the formula “=SUM(A1:A5)” represent?
a) Multiply values in A1 to A5
b) Add values in A1 to A5
c) Average values in A1 to A5
d) Count values in A1 to A5
Answer: b) Add values in A1 to A5
Question: Which programming language is commonly used for web development?
a) Java
b) C++
c) HTML
d) Python
Answer: c) HTML
Question: What is the role of an operating system in a computer?
a) Create documents
b) Manage hardware and software resources
c) Design websites
d) Perform calculations
Answer: b) Manage hardware and software resources
Question: Which of the following is an example of a malware type?
a) Firewall
b) Antivirus
c) Spyware
d) Encryption
Answer: c) Spyware
Question: What does the acronym SQL stand for?
a) System Query Language
b) Structured Query Language
c) Simple Query Language
d) Server Query Language
Answer: b) Structured Query Language
Question: In a network, what does the term “LAN” stand for?
a) Local Access Network
b) Large Area Network
c) Long-range Area Network
d) Local Area Network
Answer: d) Local Area Network
Question: What is the purpose of data validation in a database?
a) Increase data redundancy
b) Ensure data accuracy and integrity
c) Delete records
d) Encrypt data
Answer: b) Ensure data accuracy and integrity
Question: Which type of software provides an interface for users to interact with the computer?
a) Operating system
b) Database management system
c) Network protocol
d) Compiler
Answer: a) Operating system
Question: What does the acronym URL stand for?
a) Universal Resource Locator
b) Uniform Resource Locator
c) Universal Routing Locator
d) Uniform Routing Locator
Answer: b) Uniform Resource Locator
Question: In a programming context, what is the purpose of a loop?
a) Execute a set of instructions repeatedly
b) Create graphics
c) Store data permanently
d) Manage network connections
Answer: a) Execute a set of instructions repeatedly
Question: What is the main function of a router in a network?
a) Connect devices within the same network
b) Provide internet access
c) Store data
d) Manage printer connections
Answer: b) Provide internet access
Question: Which of the following is an example of a spreadsheet software?
a) Photoshop
b) Excel
c) Word
d) PowerPoint
Answer: b) Excel
Question: What is the purpose of a primary key in a database table?
a) Sort data alphabetically
b) Accelerate data retrieval
c) Ensure data uniqueness
d) Delete records
Answer: c) Ensure data uniqueness.
