WorksheetsICT Final
Total questions: 108
Worksheet time: 54mins
What does ICT stand for?
Information and Communication Technology
Internet and Computing Technology
Information Control Technology
Industrial Communication Tools
What is the primary purpose of ICT in the digital industry?
Replace manual labor entirely through automation
Facilitate communication and manage data effectively
Create social media platforms
Design gaming software
Which of the following sectors has been significantly impacted by ICT through telemedicine?
Agriculture
Retail
Healthcare
Education
What is the role of ICT in the education sector?
Improve farming practices
Automate banking transactions
Enhance retail operations
Support e-learning platforms and digital classrooms
Why are standards important in ICT?
They ensure interoperability and security between systems
They help create more gaming platforms
They improve access to social media
They reduce the need for telecommunication
What does ISO/IEC 27001 standard refer to?
Internet access control
Information security management
E-commerce platform management
Online booking systems
How does ICT support sustainable development goals (SDGs)?
By eliminating physical transactions
By increasing social media followers
By promoting inclusive and sustainable economic growth
By automating all manual tasks
What is a common application of cloud computing in ICT?
Virtual reality simulations
Managing healthcare records manually
Automating factory lines
Scalable data storage and processing
How does ICT benefit the public administration sector?
E-Government services and digital identity systems
Development of online gaming
Real-time weather monitoring
Automated customer service
What is a relational database primarily designed for?
Organizing data into multiple tables with defined relationships
Eliminating the need for data querying
Storing data in a single table with minimal structure
Managing only small-scale applications
Which of these is an example of a relational database management system (RDBMS)?
Google Sheets
JSON
MySQL
Excel
What does SQL stand for?
Simple Query Language
Sequential Query Logic
Server Query Language
Structured Query Language
In relational databases, what is a "foreign key" used for?
Establishing relationships between tables
Uniquely identifying records within a table
Storing large text data
Setting permissions for data access
What is a common file format for flat file databases?
XML
CSV
SQL
JSON
Which of the following is a characteristic of a relational database?
Data is unstructured and stored in a single file
Data cannot be related across tables
Data is organized into tables with rows and columns
Data cannot be queried or manipulated
Which SQL command is used to modify existing records in a table?
INSERT
DELETE
SELECT
UPDATE
What kind of data type is best for storing true or false values?
Boolean
Date
Text
Integer
Why is a relational database often preferred over a flat file for complex applications?
It avoids the use of structured formats
It supports relationships, large datasets, and complex queries
It stores data in a single, easy-to-read file
It requires minimal setup and maintenance
In SQL, what is the purpose of the GROUP BY clause?
To filter data based on conditions
To sort data in ascending order
To aggregate data based on specific columns
To delete specific records from a table
What is a cell in a spreadsheet?
A type of chart for data visualization
A function that calculates totals
A complete table within a spreadsheet
A single box where data is entered, identified by a combination of column and row
What is the purpose of using a primary key in data modeling?
To uniquely identify each record in a table
To format data into charts and graphs
To store multiple types of data in one cell
To automatically sort data by alphabetical order
Which of the following is an example of a data processing step?
Deleting all data without a backup
Normalizing data formats to make analysis easier
Rearranging unrelated cells in a spreadsheet
Adding random data entries
What is the purpose of a pivot table in a spreadsheet?
To permanently delete duplicate entries
To format text in a specific cell
To summarize and analyze large sets of data
To create a backup of a spreadsheet
Which of the following represents abnormal test data?
Data outside the expected range or type
Data arranged alphabetically
Data with missing entries only
Data outside the expected range or type
In spreadsheets, what does conditional formatting allow you to do?
Apply specific formatting to cells that meet certain conditions
Generate a random value for each cell
Merge cells across multiple columns
Automatically create a pivot table
What is the role of a function in a spreadsheet?
To automatically share data with other users
To perform specific calculations, such as SUM or AVERAGE
To lock cells from editing
To create data models
Which of these terms best describes changing data to fit analysis needs, such as sorting or filtering?
Data deletion
Data manipulation
Data modeling
Data cleansing only
When testing a data model, why is extreme data used?
To speed up data processing
To add random data to the dataset
To format data consistently
To verify the model’s functionality at the boundaries of valid input
What does an absolute cell reference in a spreadsheet look like?
A1:A10
$A$1
A1
Sheet1
What are the main elements of multimedia?
Sound effects and file storage
Only text and video
Text, audio, graphics, video, and animation
Text, images, and web links
In which field is multimedia used for creating computer simulations?
Cooking
Legal studies
Engineering
Literature
What is the difference between linear and non-linear multimedia?
Linear multimedia is always interactive, while non-linear is not
Linear multimedia includes text only, while non-linear includes audio
Non-linear multimedia must be broadcast live
Non-linear multimedia allows user control, while linear does not
Which is an example of interactive multimedia?
Video games
Static advertisements
Television commercials
Printed newspapers
What is a common use of multimedia in the business sector?
Marketing presentations
Onboarding printed material only
Manual document editing
Employee handbooks
Which multimedia element often takes the most storage space?
Menus
Video
Text
Graphics
How is animation typically used in multimedia?
To replace all forms of text
As a static graphic for navigation
To create an illusion of motion to enhance user experience
As the primary method for storing data
What role do authoring tools play in multimedia projects?
They manage storage hardware for multimedia
They create only video effects
They allow only text formatting
They help combine multiple media elements into a cohesive project
Why is multimedia important in the entertainment industry?
It is used to develop special effects in movies and games
It is used solely for news reporting
It enables only audio broadcasts
It limits user interaction
Which of the following best describes hypermedia?
Multimedia limited to printed text and images
Multimedia with linked elements and user interactivity
A media system that does not support user input
Audio-only content management
What is one primary use of a switch in a network?
Directs data packets to specific devices using MAC addresses
Provides IP addresses to connected devices
Converts analog signals to digital signals
Connects networks to the internet
Which device is used to connect two LAN segments together?
Modem
Bridge
Router
Hub
What is an example of a wireless networking technology with limited range, commonly used for short connections?
Satellite
Ethernet
Bluetooth
WiFi
Which type of network is confined to a single building or small area?
VPN
WAN
MAN
LAN
What is an ISP responsible for?
Providing internet access to users
Managing IP addresses within a LAN
Assigning MAC addresses to devices
Converting digital signals to analog
What is one advantage of using a cabled network over a wireless network?
Lower risk of physical damage
More stable and faster connection
Greater portability for connected devices
Easier to connect multiple devices
In which type of network are Access Points used to connect devices wirelessly?
VPN
LAN
WLAN
WAN
What information does a data packet header typically contain?
ISP account information
MAC addresses of all devices on the network
Speed of data transmission
Sender and receiver’s IP address
Which device connects a local network to the internet?
Switch
Bridge
Hub
Router
What is a benefit of storing data centrally in a network?
Easier backup and data access
Increases internet speed
Reduces the need for IP addresses
Eliminates security risks
What does HTTP stand for?
Host Transfer Terminal Protocol
HyperText Transfer Protocol
High Transfer Technology Protocol
Hyperlink Text Transmission Protocol
What is an IP address?
A standard for web page layout
A name for a specific web server
A numerical label assigned to each device connected to a network
A type of email protocol
Which browser was the first widely used GUI web browser?
Safari
Netscape
Internet Explorer
Mosaic
What is a Uniform Resource Name (URN)?
A name that uniquely identifies a resource without locating it
A URL that points to a specific web page
An email server identifier
A tool for browsing the internet
Which protocol is typically used for file transfers over the Internet?
POP3
FTP
HTTP
SMTP
What is the main function of a web browser?
To manage domain names
To run server-side applications
To retrieve and display web documents
To store and organize network addresses
Which of the following technologies is commonly used to style web pages?
DNS
FTP
SQL
CSS
What is an example of a web-based email client?
Gmail
Microsoft Outlook
Mozilla Thunderbird
IBM Lotus Notes
Which protocol is connection-oriented and used to transfer mail over the internet?
HTTP
SMTP
FTP
POP3
In CSS, what does "cascading" refer to?
The layering of multimedia elements
The hierarchy of DNS servers
The order of precedence for style sources (inline, internal, external)
The arrangement of HTML tags
What is the main role of a web browser in web development?
To encrypt data for secure transmission
To host websites on the internet
To compile code into machine language
To access and display web content
Which tag is used to create a hyperlink in HTML?
a
link
href
url
What element should you use to create a numbered list in HTML?
di
ol
ul
li
Which of the following is an example of inline CSS?
link rel="stylesheet" href="styles.css"
p class="blue-text" This
is blue text. /p
p style="color: blue;" This is blue text. /p
style p { color: blue; } /style
What is the purpose of the <meta> tag in the <head> section of an HTML document?
To include JavaScript code
To link to external images
To define CSS rules
To provide metadata such as descriptions and keywords
Which HTML element is used for the largest heading?
h1
h6
header
title
What is one advantage of using external stylesheets?
Enhanced security for the website
Reusability across multiple web pages
Faster loading time of individual pages
Ability to include images directly in CSS
Which CSS property is used to change the background color of an element?
border-color
background-image
background-color
color
What is the main function of the rendering engine in a web browser?
To manage domain name resolution
To handle database queries
To secure user data on the website
To interpret HTML, CSS, and JavaScript and display the content
What is e-government primarily concerned with?
Using electronic means to deliver government services
Managing social networks
Creating virtual private networks
Developing e-commerce platforms
Which of the following is an example of Government-to-Citizens (G2C) services?
E-learning course creation
Online tax filing
Employee performance evaluations
Business inventory management
What is the main benefit of e-procurement in e-government?
Increased website visitor traffic
Reduced security concerns
Improved efficiency in purchasing goods and services
Enhanced personal communication with citizens
Which category does mobile government (m-government) belong to?
E-commerce
E-learning
E-business
E-government
What is a drawback of e-learning according to the lecture?
Lack of face-to-face interaction
Inability to store digital records
Limited access to e-books
High cost of online resources
In the context of e-health, what is an Electronic Medical Record (EMR)?
A social media platform for doctors
A digital version of a patient's medical history
A secure network for business transactions
A tool for managing e-learning courses
Which of the following is a potential disadvantage of e-books?
Increased paper usage
Increased manufacturing costs
Limited sense of ownership compared to printed books
Reduced portability
What is Government 2.0 primarily focused on?
Implementing traditional classroom-based learning
Enhancing physical government offices
Using paper-based forms for record-keeping
Integrating social networking to improve government services
Which of the following is a characteristic of the sharing economy?
Peer-to-peer services like ride sharing and accommodation sharing
Exclusive access to government services
Mandatory participation in public projects
Providing services only to businesses
What is a primary benefit of using e-learning management systems?
Physical interaction among students
Streamlined organization and tracking of learning materials
Creation of printed learning materials
Offline access to courses
What is a common safety measure to prevent tripping over cables in an ICT lab?
Allow cables to hang freely
Remove all cables from desks
Use cable ducts to cover wires
Keep cables on the floor
What is the purpose of e-safety?
To block all social media access
To increase computer processing speed
To promote physical security
To protect personal data and ensure safe online practices
Which of the following describes hacking?
Unauthorized access to a computer system
Authorized software updates
Sending spam emails
Regular software maintenance
What does anti-spyware software help prevent?
Loss of hardware
Monitoring of user activity and keylogging
Slow internet speeds
Virus infections
Which method is commonly used to prevent phishing?
Sharing sensitive data freely
Saving passwords in browsers
Using email filters to block untrusted sources
Disabling antivirus software
What is the purpose of a firewall?
To increase computer storage space
To decrease computer processing power
To share files across networks
To examine and filter network traffic for potential threats
How does encryption protect data?
By converting data into an unreadable format
By deleting unused files
By using weak passwords
By installing antivirus software
What is a digital certificate used for?
Sharing data on social media
Verifying the identity of the sender in online transactions
Encrypting email messages
Blocking spam emails
What is a common effect of a computer virus?
Improving battery life
Blocking internet access permanently
Slowing down or crashing the computer
Increasing the computer's speed
Which of the following is a moral issue in ICT?
Encrypting sensitive information
Using complex passwords
Installing software updates
Creating a fake website to deceive users
What is one positive effect of IT on employment?
Increased demand for website designers
Decreased need for software developers
Reduced need for IT support specialists
Fewer opportunities for network managers
Which of the following is an effect of IT on working patterns within organizations?
Reduced importance of smartphones
Increased opportunities for remote work
Decreased need for digital communication tools
Increased need for on-site work only
What is a disadvantage of remote working for employees?
Increased commuting time
Less flexible working hours
Potential for feeling isolated
Higher likelihood of missing family events
Which of these is a microprocessor-controlled household device?
Desktop computer
Office desk lamp
Wireless router
Washing machine
What is an advantage of using microprocessor-controlled devices in the home?
They allow for more leisure time
They make tasks more physically demanding
They require constant manual operation
They discourage healthy lifestyles
How can Repetitive Strain Injury (RSI) be prevented?
Sitting in a fixed posture all day
Using a wrist support while typing
Increasing screen brightness
Using a low-resolution screen
What is a health risk associated with prolonged computer use?
Better physical fitness
Increased cardiovascular health
Eyestrain from staring at screens
Finger numbness from less typing
Which ergonomic measure helps to reduce back problems from IT use?
Typing continuously without breaks
Increasing screen brightness
Using a non-adjustable wooden chair
Using an adjustable ergonomic chair
Which working pattern allows employees to work fewer days but with longer hours?
Compressed hours
Part-time hours
Full-time hours
Job-sharing
What is one advantage for employers when employees work remotely?
Higher transportation costs
Reduced need for office space
Increased direct supervision
Decreased productivity
What is ICT?
A type of computer processor
A cloud-based storage system
Technologies for telecommunications, broadcast media, and network systems
Software specifically for business use
Why is studying ICT development important?
It focuses only on historical developments in technology
It only applies to large corporations
It limits job opportunities
It drives global economic growth and helps understand future trends
What is a key benefit of free software?
Accessibility and customization
Higher cost for users
Limited community support
Restricted use in government sectors
Why is IT considered a hotbed for entrepreneurship?
High setup costs and limited global reach
Low-cost entry, global access, and high demand for innovation
Only large companies invest in IT
Lack of technological infrastructure
What is an example of a successful IT startup ecosystem?
Coastal fishing towns
Rural farming areas
Silicon Valley
Traditional manufacturing hubs
What is a main challenge for IT startups?
Lack of government support in developed nations
High physical infrastructure requirements
Decreasing demand for digital solutions
Funding issues and market competition
How do acceleration programs assist startups?
They provide short-term, intense support for growth
They are only focused on manufacturing sectors
They mainly offer personal loans
They replace the need for any mentorship
What is a major benefit of developing electronic payment infrastructure?
Increases transaction times
Supports e-commerce and financial inclusion
Reduces security of online payments
Limits access to financial services
What is one way ICT improves logistics infrastructure?
Reduced use of real-time tracking
Manual processing of logistics
Digital tracking and AI in warehouse management
Decreasing use of cloud-based systems
Which of the following is a future trend to watch in ICT development?
Limited growth in digital payments
Elimination of free software in startups
Decrease in e-health applications
AI in automation and blockchain for secure transactions
