What is the role of a function in a spreadsheet?

To perform specific calculations, such as SUM or AVERAGE

What is the main role of a web browser in web development?

To access and display web content

What is a common effect of a computer virus?

Slowing down or crashing the computer

Why is IT considered a hotbed for entrepreneurship?

Low-cost entry, global access, and high demand for innovation

What is the difference between linear and non-linear multimedia?

Non-linear multimedia allows user control, while linear does not

Which of the following is an example of a data processing step?

Normalizing data formats to make analysis easier

Why is multimedia important in the entertainment industry?

It is used to develop special effects in movies and games

What is one way ICT improves logistics infrastructure?

Digital tracking and AI in warehouse management

What are the main elements of multimedia?

Text, audio, graphics, video, and animation

What is a Uniform Resource Name (URN)?

A name that uniquely identifies a resource without locating it

What is Government 2.0 primarily focused on?

Integrating social networking to improve government services

What is an advantage of using microprocessor-controlled devices in the home?

They allow for more leisure time

Which of the following is an effect of IT on working patterns within organizations?

Increased opportunities for remote work

What is the purpose of a firewall?

To examine and filter network traffic for potential threats

What is a health risk associated with prolonged computer use?

Eyestrain from staring at screens

What is a cell in a spreadsheet?

A single box where data is entered identified byA combination of column&row

Which of the following is a characteristic of the sharing economy?

Peer-to-peer services like ride sharing and accommodation sharing

What is the purpose of e-safety?

To protect personal data and ensure safe online practices

What is the purpose of using a primary key in data modeling?

To uniquely identify each record in a table

What does anti-spyware software help prevent?

Monitoring of user activity and keylogging

What is a key benefit of free software?

Accessibility and customization

What is the purpose of the tag in the section of an HTML document?

To provide metadata such as descriptions and keywords

What is one positive effect of IT on employment?

Increased demand for website designers

How is animation typically used in multimedia?

To create an illusion of motion to enhance user experience

Which of the following represents abnormal test data?

Data outside the expected range or type

Which of the following is a future trend to watch in ICT development?

AI in automation and blockchain for secure transactions

Which of the following is a characteristic of a relational database?

Data is organized into tables with rows and columns

In SQL, what is the purpose of the GROUP BY clause?

To aggregate data based on specific columns

What is one advantage of using a cabled network over a wireless network?

More stable and faster connection

What is the purpose of a pivot table in a spreadsheet?

To summarize and analyze large sets of data

What is the main benefit of e-procurement in e-government?

Improved efficiency in purchasing goods and services

Which method is commonly used to prevent phishing?

Using email filters to block untrusted sources

What is the main function of a web browser?

To retrieve and display web documents

What is an IP address?

A numerical label assigned to each device connected to a network

studbud

ICT 100 6-15Lec

100 termsStudBud Administration50 plays

Imported from external platform

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

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

ICT 100 6-15Lec Flashcards | StudBud