-
web.groovymark@gmail.com
- November 28, 2024
Question 01
What is the primary purpose of Structured Query Language (SQL)?
- a) To design web pages
- b) To manipulate and query data in relational databases
- c) To manage networking protocols
- d) To encrypt sensitive information
Correct Answer: b) To manipulate and query data in relational databases
Explanation: SQL is the standard language used to query, update, and manage data in relational databases.
Question 02
Which of the following refers to the process of combining large datasets for analysis?
- a) Data Mining
- b) Data Warehousing
- c) Data Encryption
- d) Data Validation
Correct Answer: b) Data Warehousing
Explanation: Data warehousing is the process of combining large amounts of data from multiple sources into a central repository for analysis.
Question 03
Which component of a computer network manages and directs data traffic between devices on the same network?
- a) Router
- b) Firewall
- c) Switch
- d) Modem
Correct Answer: c) Switch
Explanation: A switch is used to manage data traffic within a network by directing packets to their intended destination within the network.
Question 04
What is the function of a bus topology in networking?
- a) Connects each computer to a central node
- b) Connects all devices in a linear fashion with a common backbone
- c) Connects devices in a ring formation
- d) Connects multiple LANs across a wide area
Correct Answer: b) Connects all devices in a linear fashion with a common backbone
Explanation: In a bus topology, each device is connected to a central communication line, or backbone, which has two endpoints.
Question 05
Which technology allows the transmission of voice, video, and text data over the internet?
- a) VoIP
- b) HTTP
- c) DNS
- d) VPN
Correct Answer: a) VoIP
Explanation: VoIP (Voice over Internet Protocol) allows voice, video, and text data to be transmitted over the internet instead of traditional phone lines.
Question 06
What does the acronym RDBMS stand for?
- a) Random Data Backup Management System
- b) Relational Database Management System
- c) Resource Data Backup and Management System
- d) Remote Database Management Software
Correct Answer: b) Relational Database Management System
Explanation: RDBMS stands for Relational Database Management System, which is used to manage data in tables with relationships between them.
Question 07
What is the purpose of an Ethernet cable in networking?
- a) To provide wireless connectivity
- b) To connect devices to a wired network
- c) To increase internet speed
- d) To store data locally
Correct Answer: b) To connect devices to a wired network
Explanation: Ethernet cables are used to connect devices to a wired local area network (LAN) for communication and data sharing.
Question 08
Which term refers to the data stored in rows and columns in a database?
- a) Field
- b) Record
- c) Table
- d) Query
Correct Answer: c) Table
Explanation: A table is a collection of related data stored in rows and columns in a database.
Question 09
Which protocol is responsible for secure communication over the internet?
- a) FTP
- b) HTTP
- c) HTTPS
- d) SMTP
Correct Answer: c) HTTPS
Explanation: HTTPS (Hypertext Transfer Protocol Secure) is used for secure communication over the internet, ensuring data encryption during transmission.
Question 10
Which network topology connects all devices in a circular format?
- a) Bus
- b) Star
- c) Ring
- d) Mesh
Correct Answer: c) Ring
Explanation: In a ring topology, devices are connected in a circular format, with each device linked to two others in the network.
Question 11
Which term describes a set of protocols used to communicate data over the internet?
- a) DNS
- b) HTTP
- c) TCP/IP
- d) FTP
Correct Answer: c) TCP/IP
Explanation: TCP/IP (Transmission Control Protocol/Internet Protocol) is a set of protocols that define how data is communicated over the internet.
Question 12
Which device is used to connect a private network to the internet?
- a) Switch
- b) Modem
- c) Server
- d) Proxy
Correct Answer: b) Modem
Explanation: A modem is a device used to connect a private network to the internet by converting digital data into a format suitable for transmission over telephone lines or cables.
Question 13
Which tool is used to create visualizations from large datasets to gain insights?
- a) Spreadsheet Software
- b) Tableau
- c) SQL
- d) Microsoft Word
Correct Answer: b) Tableau
Explanation: Tableau is a powerful tool used for creating visualizations from large datasets to help organizations gain insights from their data.
Question 14
What is the primary function of a firewall?
- a) To route data between networks
- b) To protect a network from unauthorized access
- c) To speed up data transfer
- d) To store backup data
Correct Answer: b) To protect a network from unauthorized access
Explanation: A firewall is used to block unauthorized access to a network while allowing legitimate traffic to pass through.
Question 15
Which component of the cloud allows businesses to store data and applications remotely?
a) To provide internet access for instances in private subnets
b) To enforce security group policies
c) To monitor VPC traffic
d) To manage DNS queries
- a) Virtual Machine
- b) Cloud Storage
- c) Ethernet Cable
- d) Local Server
Question 16
What is the purpose of a Gantt chart in project management?
- a) To represent the hierarchy of tasks
- b) To visually display the project schedule
- c) To assign team members to tasks
- d) To record project risks
Correct Answer: b) To visually display the project schedule
Explanation: A Gantt chart is a visual tool used in project management to display the project schedule, including tasks and timelines.
Question 17
Which device allows multiple computers to communicate with each other over a network?
- a) Router
- b) Firewall
- c) Switch
- d) Modem
Correct Answer: a) Router
Explanation: A router allows multiple computers and devices to communicate with each other over a network and provides internet access by routing data between networks.
Question 18
Which component of a computer stores temporary data for quick access by the CPU?
- a) Hard Drive
- b) RAM
- c) SSD
- d) BIOS
Correct Answer: b) RAM
Explanation: RAM (Random Access Memory) stores temporary data that the CPU can quickly access while running programs.
Question 19
What does the acronym GUI stand for in computing?
- a) General User Information
- b) Graphical User Interface
- c) Global User Integration
- d) Generic Utility Interface
Correct Answer: b) Graphical User Interface
Explanation: GUI (Graphical User Interface) refers to the visual system that allows users to interact with a computer using graphical elements like icons and buttons.
Question 20
Which tool is primarily used for analyzing large datasets and identifying patterns?
- a) Data Encryption
- b) Data Mining
- c) Data Validation
- d) Data Querying
Correct Answer: b) Data Mining
Explanation: Data mining is the process of analyzing large datasets to identify patterns, trends, and insights that can inform decision-making.
