What is a relational database primarily designed for?

Organizing data into multiple tables with defined relationships

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

To uniquely identify each record in a table

What is a cell in a spreadsheet?

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

What is a digital certificate used for?

Verifying the identity of the sender in online transactions

What is the main function of the rendering engine in a web browser?

To interpret HTML, CSS, and JavaScript and display the content

Which of the following is a moral issue in ICT?

Creating a fake website to deceive users

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

To summarize and analyze large sets of data

What is an IP address?

A numerical label assigned to each device connected to a network

Which of the following is a potential disadvantage of e-books?

Limited sense of ownership compared to printed books

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

To aggregate data based on specific columns

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

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

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

Improved efficiency in purchasing goods and services

What is the purpose of a firewall?

To examine and filter network traffic for potential threats

In the context of e-health, what is an Electronic Medical Record (EMR)?

A digital version of a patient’s medical history

What is a Uniform Resource Name (URN)?

A name that uniquely identifies a resource without locating it

What is the role of a function in a spreadsheet?

To perform specific calculations, such as SUM or AVERAGE

In CSS, what does “cascading” refer to?

The order of precedence for style sources (inline, internal, external)

Why is IT considered a hotbed for entrepreneurship?

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

What is e-government primarily concerned with?

Using electronic means to deliver government services

In relational databases, what is a “foreign key” used for?

Establishing relationships between tables

Why is multimedia important in the entertainment industry?

It is used to develop special effects in movies and games

What is a major benefit of developing electronic payment infrastructure?

Supports e-commerce and financial inclusion

Why is a relational database often preferred over a flat file for complex applications?

It supports relationships, large datasets, and complex queries

What are the main elements of multimedia?

Text, audio, graphics, video, and animation

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

Increased opportunities for remote work

Which of the following best describes hypermedia?

Multimedia with linked elements and user interactivity

How does encryption protect data?

By converting data into an unreadable format

What is one primary use of a switch in a network?

Directs data packets to specific devices using MAC addresses

What does anti-spyware software help prevent?

Monitoring of user activity and keylogging

What is an ISP responsible for?

Providing internet access to users

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

Data is organized into tables with rows and columns

Which of the following describes hacking?

Unauthorized access to a computer system

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

AI in automation and blockchain for secure transactions

What is one positive effect of IT on employment?

Increased demand for website designers

What is Government 2.0 primarily focused on?

Integrating social networking to improve government services

What is a primary benefit of using e-learning management systems?

Streamlined organization and tracking of learning materials

studbud

ICT 100 6-15Lec

100 termsStudBud Administration50 plays

Imported from external platform

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

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

ICT 100 6-15Lec Flashcards | StudBud