WorksheetsRelational Databases and Multimedia Quiz
Total questions: 57
Worksheet time: 57mins
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
