NEW
Font size
WorksheetsFMELEC412
Total questions: 50
Worksheet time: 38mins
It is a standardized language used to manage and interact with relational databases.
DBMS
HTML
SQL
ITDS
It is one of the most popular open-source relational database management systems.
Excel
MySQL
Java
HTML
A collection of organized data.
SQL
Database
Productivity Tools
Browser
Structure within a database that stores data in rows and columns.
Row
Table
Primary Key
Column
A single entry in a table.
Table
Row
Primary Key
Column
A data attribute within a table.
Row
Column
Foreign Key
Primary Key
A unique identifier for each record.
Foreign Key
Row
Primary Key
Column
A field that creates a relationship between two tables.
Primary Key
Row
Foreign Key
Column
Defines and modifies the structure of the database.
Data Manipulation Language
Data Definition Language
Data Control Language
Data Query Language
Manages and manipulates data stored in tables.
Data Manipulation Language
Data Control Language
Data Query Language
Data Definition Language
Retrieves data from the database.
Data Manipulation Language
Data Control Language
Data Query Language
Data Definition Language
Controls user access and permissions.
Data Control Language
Data Query Language
Data Manipulation Language
Data Definition Language
A command in SQL used to add new records (rows) into a table in a database.
INSERT
ADD
INPUT
INCLUDE
SQL command used to create database.
MAKE
CREATE
BUILD
CONSTRUCT
What does the SELECT statement do in SQL?
To retrieve or get data from a database table
To create database
To add new record into a table in a database
To connect tables that have a matching relationship
A command in SQL used to modify or change existing data in a table.
ALTER
CHANGE
UPDATE
MODIFY
A command in SQL used to remove rows from a table.
REMOVE
MOVE
DELETE
EXCLUDE
Which aggregate function would you use to find the average score of students?
SUM()
AVG()
COUNT()
MAX()
What does the COUNT() function do in SQL?
Counts number of rows
Adds numeric values
Returns minimum value
Returns maximum value
What function should you use to get the smallest value in a dataset?
COUNT()
MIN()
SUM()
MAX()
What does the JOIN statement do in SQL?
To add new record into a table in a database
To connect tables that have a matching relationship
To retrieve or get data from a database table
To create database
A command used to give permissions or access rights to users on database objects such as tables, views, or the entire database.
GRANT
ALLOW
REVOKE
PERMIT
A command used to remove or take back previously granted permissions from a user.
GRANT
VOID
REVOKE
STOP
It refers to raw facts or figures that have not yet been processed or interpreted.
Information
Bits
Data
Web
It refers to any data that is made available on websites.
Database
Web Data
Information
Personal Data
It refers to protecting personal information from unauthorized access.
Data Privacy
Data Control
Data Integrity
Data Access
Unauthorized access by hackers to stored user information.
Data Breaches
Malware
Phishing
Virus
Software designed to steal or damage data on your device.
Phishing
Malware
Virus
Data Breaches
Fake messages or emails that trick users into giving personal information.
Malware
Phishing
Data Breaches
Virus
It refers to everyday devices connected to the internet that collect or exchange data.
Data Breaches
IoT
AI
What does API stand for?
Application Programming Interface
Active Privacy Interaction
Automated Programming Interface
Advanced Processing Information
Which of the following is NOT personal data?
Password
Weather forecast
Full name
Credit card information
Best practices for data security include:
Updating applications
Clicking all links
Sharing passwords
Using weak passwords
What does IoT stand for?
Internet of Things
Interactive Online Tools
Internet of Technology
Integration of Tools
Which of the following is an IoT device?
USB flash drive
Smartwatch
Central Processing Unit
Desktop monitor
Future trend in data includes:
No changes in data privacy laws
Less automation
Fewer connected devices
Artificial intelligence everywhere
Why is data considered the backbone of the digital world?
It enables communication, automation, and decision-making
It limits access to online services and applications
It stores movies, music, and other digital content
It replaces human interaction across all platforms
How does manual access of web data differ from API access?
Manual retrieves real-time data, API retrieves static data only
Manual and API function exactly the same way
Manual requires user effort, API allows automatic data exchange
Manual is less secure, API is never encrypted
Netflix recommends shows based on:
User viewing history, duration, and interaction patterns
Trending content determined by advertisements
Randomly selected content from its library
The speed and quality of the user's internet connection
How do IoT devices and data collection interact to improve services?
Devices store data locally without sending it to apps
Devices collect data but cannot perform automated actions
Devices collect data, analyze it, and adapt to user behavior
Data collection replaces the need for devices entirely
Which best distinguishes phishing from malware?
Malware tricks users for info; phishing deletes device files
Both phishing and malware steal the same type of data
Phishing tricks users for info; malware steals data from devices
Phishing occurs on devices; malware occurs online only
How can big data and AI improve user experiences online?
By analyzing large datasets to create personalized recommendations
By slowing down processing to manage traffic
By randomly adjusting content based on global trends
By deleting outdated or unnecessary user files automatically
Why are stronger data privacy laws important for the internet?
To protect user data and regulate company data usage
To limit access to online services for all users
To prevent AI systems from collecting personal information
To block IoT devices from connecting to networks
You receive an email asking for your password. What should you do?
Ignore the email but click any included links
Report it as phishing and do not share information
Reply immediately with your credentials
Save the email and forward it to others for advice
Your smartwatch tracks heart rate and sleep. How can this data be used?
To send personalized advertisements and promotions
To delete old data and optimize storage automatically
To predict health trends and suggest lifestyle improvements
To store information only for device manufacturers
To get real-time weather info in an app, you should:
Use an API to retrieve accurate data programmatically
Manually check websites and enter data yourself
A company wants to recommend products based on customer behavior. What should it use?
Randomized selection of popular items online
Customer browsing patterns and purchase history
General product information from suppliers
Social media trends only without internal data
If a smart home camera detects motion while you are away, what happens?
The camera deletes footage immediately to save space
The camera sends data to the cloud and alerts the user
The camera disables the internet connection automatically
The camera stores footage locally for later review
To secure your social media account, which combination is best?
Using the same password for multiple accounts for convenience
Strong passwords, two-factor authentication, and avoiding suspicious links
Logging in only on public Wi-Fi to avoid device issues
Sharing passwords with trusted friends for backup
How does decentralized data storage using blockchain help users?
Allows companies to fully manage user data on private servers
Gives users more control and security over their personal data
Prevents AI from accessing user information entirely
Eliminates the need for internet connectivity for apps
