Font size
WorksheetsRelational Databases and Multimedia Quiz
Total questions: 100
Worksheet time: 50mins
What is a relational database primarily designed for?
Organizing data into multiple tables with defined relationships
Storing data in a single table with minimal structure
Managing only small-scale applications
Eliminating the need for data querying
Which of these is an example of a relational database management system (RDBMS)?
MySQL
Excel
Google Sheets
JSON
What does SQL stand for?
Structured Query Language
Simple Query Language
Sequential Query Logic
Server 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?
CSV
SQL
JSON
XML
Which of the following is a characteristic of a relational database?
Data is organized into tables with rows and columns
Data is unstructured and stored in a single file
Data cannot be queried or manipulated
Data cannot be related across tables
Which SQL command is used to modify existing records in a table?
UPDATE
SELECT
DELETE
INSERT
What kind of data type is best for storing true or false values?
Boolean
Integer
Text
Date
Why is a relational database often preferred over a flat file for complex applications?
It supports relationships, large datasets, and complex queries
It stores data in a single, easy-to-read file
It requires minimal setup and maintenance
It avoids the use of structured formats
In SQL, what is the purpose of the GROUP BY clause?
To aggregate data based on specific columns
To filter data based on conditions
To delete specific records from a table
To sort data in ascending order
What element should you use to create a numbered list in HTML?
ol
ul
li
dl
Which of the following is an example of inline CSS?
p style="color: blue;" This is blue text. /p
link rel="stylesheet" href="styles.css"
style p { color: blue; } /style
p class="blue-text" This is blue text. /p
What is the purpose of the tag in the
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
Which HTML element is used for the largest heading?
h1
h6
header
title
What is one advantage of using external stylesheets?
Reusability across multiple web pages
Faster loading time of individual pages
Ability to include images directly in CSS
Enhanced security for the website
Which CSS property is used to change the background color of an element?
background-color
color
background-image
border-color
What is the main function of the rendering engine in a web browser?
To interpret HTML, CSS, and JavaScript and display the content
To secure user data on the website
To manage domain name resolution
To handle database queries
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?
Online tax filing
Employee performance evaluations
Business inventory management
E-learning course creation
What is the main benefit of e-procurement in e-government?
Improved efficiency in purchasing goods and services
Increased website visitor traffic
Enhanced personal communication with citizens
Reduced security concerns
Which category does mobile government (m-government) belong to?
E-government
E-commerce
E-business
E-learning
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 digital version of a patient's medical history
A secure network for business transactions
A tool for managing e-learning courses
A social media platform for doctors
Which of the following is a potential disadvantage of e-books?
Limited sense of ownership compared to printed books
Increased paper usage
Reduced portability
Increased manufacturing costs
What is Government 2.0 primarily focused on?
Integrating social networking to improve government services
Implementing traditional classroom-based learning
Enhancing physical government offices
Using paper-based forms for record-keeping
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?
Streamlined organization and tracking of learning materials
Creation of printed learning materials
Offline access to courses
Physical interaction among students
What is a common safety measure to prevent tripping over cables in an ICT lab?
Use cable ducts to cover wires
Allow cables to hang freely
Keep cables on the floor
Remove all cables from desks
What is the purpose of e-safety?
To protect personal data and ensure safe online practices
To block all social media access
To promote physical security
To increase computer processing speed
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?
Monitoring of user activity and keylogging
Slow internet speeds
Virus infections
Loss of hardware
Which method is commonly used to prevent phishing?
Using email filters to block untrusted sources
Saving passwords in browsers
Disabling antivirus software
Sharing sensitive data freely
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
How does encryption protect data?
By converting data into an unreadable format
By deleting unused files
By installing antivirus software
By using weak passwords
What is a digital certificate used for?
Verifying the identity of the sender in online transactions
Encrypting email messages
Blocking spam emails
Sharing data on social media
What is a common effect of a computer virus?
Slowing down or crashing the computer
Increasing the computer's speed
Improving battery life
Blocking internet access permanently
Which of the following is a moral issue in ICT?
Creating a fake website to deceive users
Installing software updates
Using complex passwords
Encrypting sensitive information
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?
Increased opportunities for remote work
Decreased need for digital communication tools
Increased need for on-site work only
Reduced importance of smartphones
What is a disadvantage of remote working for employees?
Potential for feeling isolated
Increased commuting time
Higher likelihood of missing family events
Less flexible working hours
Which of these is a microprocessor-controlled household device?
Washing machine
Desktop computer
Office desk lamp
Wireless router
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?
Using a wrist support while typing
Sitting in a fixed posture all day
Increasing screen brightness
Using a low-resolution screen
What is a health risk associated with prolonged computer use?
Eyestrain from staring at screens
Finger numbness from less typing
Better physical fitness
Increased cardiovascular health
Which ergonomic measure helps to reduce back problems from IT use?
Using an adjustable ergonomic chair
Typing continuously without breaks
Increasing screen brightness
Using a non-adjustable wooden 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?
Reduced need for office space
Increased direct supervision
Decreased productivity
Higher transportation costs
What is ICT?
Technologies for telecommunications, broadcast media, and network systems
A type of computer processor
Software specifically for business use
A cloud-based storage system
Why is studying ICT development important?
It drives global economic growth and helps understand future trends
It focuses only on historical developments in technology
It only applies to large corporations
It limits job opportunities
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?
Low-cost entry, global access, and high demand for innovation
High setup costs and limited global reach
Only large companies invest in IT
Lack of technological infrastructure
What is an example of a successful IT startup ecosystem?
Silicon Valley
Rural farming areas
Traditional manufacturing hubs
Coastal fishing towns
What is a main challenge for IT startups?
Funding issues and market competition
Lack of government support in developed nations
High physical infrastructure requirements
Decreasing demand for digital solutions
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?
Supports e-commerce and financial inclusion
Increases transaction times
Limits access to financial services
Reduces security of online payments
What is one way ICT improves logistics infrastructure?
Digital tracking and AI in warehouse management
Decreasing use of cloud-based systems
Reduced use of real-time tracking
Manual processing of logistics
Which of the following is a future trend to watch in ICT development?
AI in automation and blockchain for secure transactions
Decrease in e-health applications
Elimination of free software in startups
Limited growth in digital payments
What is a cell in a spreadsheet?
A single box where data is entered, identified by a combination of column and row
A complete table within a spreadsheet
A function that calculates totals
A type of chart for data visualization
What is the purpose of using a primary key in data modeling?
To uniquely identify each record in a table
To store multiple types of data in one cell
To automatically sort data by alphabetical order
To format data into charts and graphs
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
Adding random data entries
Rearranging unrelated cells in a spreadsheet
What is the purpose of a pivot table in a spreadsheet?
To summarize and analyze large sets of data
To create a backup of a spreadsheet
To permanently delete duplicate entries
To format text in a specific cell
Which of the following represents abnormal test data?
Data outside the expected range or type
Data that is typical and expected
Data with missing entries only
Data arranged alphabetically
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
What is the role of a function in a spreadsheet?
To perform specific calculations, such as SUM or AVERAGE
To lock cells from editing
To create data models
To automatically share data with other users
Which of these terms best describes changing data to fit analysis needs, such as sorting or filtering?
Data manipulation
Data modeling
Data deletion
Data cleansing only
When testing a data model, why is extreme data used?
To verify the model’s functionality at the boundaries of valid input
To add random data to the dataset
To format data consistently
To speed up data processing
What does an absolute cell reference in a spreadsheet look like?
$A$1
A1
А1:A10
Sheet1
What are the main elements of multimedia?
Text, audio, graphics, video, and animation
Only text and video
Text, images, and web links
Sound effects and file storage
In which field is multimedia used for creating computer simulations?
Engineering
Cooking
Literature
Legal studies
What is the difference between linear and non-linear multimedia?
Non-linear multimedia allows user control, while linear does not
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
Which is an example of interactive multimedia?
Video games
Television commercials
> Printed newspapers
Static advertisements
What is a common use of multimedia in the business sector?
Marketing presentations
> Manual document editing
Employee handbooks
Onboarding printed material only
Which multimedia element often takes the most storage space?
Video
Text
Graphics
Menus
How is animation typically used in multimedia?
To create an illusion of motion to enhance user experience
> As a static graphic for navigation
As a static graphic for navigation
As the primary method for storing data
What role do authoring tools play in multimedia projects?
They help combine multiple media elements into a cohesive project
They create only video effects
They allow only text formatting
They manage storage hardware for multimedia
Why is multimedia important in the entertainment industry?
It is used to develop special effects in movies and games
It enables only audio broadcasts
It limits user interaction
It is used solely for news reporting
Which of the following best describes hypermedia?
Multimedia with linked elements and user interactivity
Multimedia limited to printed text and images
Audio-only content management
A media system that does not support user input
What is one primary use of a switch in a network?
Directs data packets to specific devices using MAC addresses
Converts analog signals to digital signals
Connects networks to the internet
Provides IP addresses to connected devices
Which device is used to connect two LAN segments together?
Bridge
Router
Hub
Modem
What is an example of a wireless networking technology with limited range, commonly used for short connections?
Bluetooth
WiFi
Satellite
Ethernet
Which type of network is confined to a single building or small area?
LAN
WAN
MAN
VPN
What is an ISP responsible for?
Providing internet access to users
Assigning MAC addresses to devices
Converting digital signals to analog
Managing IP addresses within a LAN
What is one advantage of using a cabled network over a wireless network?
More stable and faster connection
Greater portability for connected devices
Easier to connect multiple devices
Lower risk of physical damage
In which type of network are Access Points used to connect devices wirelessly?
WLAN
LAN
WAN
VPN
What information does a data packet header typically contain?
Sender and receiver’s IP address
MAC addresses of all devices on the network
Speed of data transmission
SP account information
Which device connects a local network to the internet?
Router
Switch
Bridge
Hub
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?
HyperText Transfer Protocol
High Transfer Technology Protocol
Hyperlink Text Transmission Protocol
Host Transfer Terminal Protocol
What is an IP address?
A numerical label assigned to each device connected to a network
A name for a specific web server
A type of email protocol
A standard for web page layout
Which browser was the first widely used GUI web browser?
Mosaic
Internet Explorer
Netscape
Safari
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?
FTP
HTTP
SMTP
POP3
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
Which of the following technologies is commonly used to style web pages?
CSS
SQL
FTP
DNS
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?
SMTP
POP3
HTTP
FTP
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
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
Which tag is used to create a hyperlink in HTML?
a
link
href
url
What does HTTP stand for?
HyperText Transfer Protocol
High-speed Transmission Protocol
Hyperlink Transfer Process
Hypertext Template Program
