WorksheetsICT Final
Total questions: 95
Worksheet time: 48mins
What is a database?
Programming language
Operating system
Organized collection of related data
Network protocol
What is data?
Processed information
Instructions for the computer
Raw facts and figures
Database table
What does the abbreviation DBMS stand for?
Primary database storage
Binary data management system
Database management system
Digital model database system
What is the purpose of a database management system (DBMS)?
To write programs
To connect computers
To create, manage, and manipulate databases
To design websites
What is a database management system based on tables and relationships?
A database without tables
A network system
A database management system based on tables and relationships
A programming language
What does the abbreviation OORDBMS stand for?
Object-oriented relational binary database management system
Online object database
Object-oriented relational database management system
Open Office relational DBMS
What is a database schema?
Backup of the database
Type of query
Logical structure of the database
Programming language
What does a row in a database table represent?
Field
Column
Record (tuple)
Key
What is another name for a column in a table?
Record
Tuple
Field
Schema
Which element stores actual values in a table?
Key
Schema
Field
Query
What is a primary key?
Duplicate value
Foreign value
A field that uniquely identifies each record
Computed value
What property is mandatory for a primary key?
Can be NULL
Can be duplicated
Must be unique and not NULL
Can change frequently
What is a foreign key?
Primary key in the same table
Random number
Field that references a primary key in another table
Field without values
What is the main purpose of a foreign key?
Increase speed
Encrypt data
Establish a relationship between tables
Store text
Which key guarantees the absence of duplicate values but can be NULL?
Primary key
Foreign key
Unique key
Composite key
What is a relationship in a database?
Backup of a table
Query
Logical relationship between tables
Column type
What type of relationship allows one record to be associated with multiple records?
One-to-One
Many-to-Many
One-to-Many
One-to-Nobody
What ensures referential integrity?
Tables load faster
Queries are optimized
Foreign keys correctly reference existing primary keys
Data is encrypted
What happens if referential integrity is violated?
The database stops working
Data is encrypted
Inconsistent or invalid data appears
Tables are deleted
Which key ensures referential integrity?
Primary key
Foreign key
Unique key
Composite key
Which SQL command is used to create a table?
ADD
INSERT
CREATE
UPDATE
Which SQL operator inserts new data?
ADD DATA
PUT
INSERT INTO
SELECT
What does the SELECT operator do?
Inserts data
Deletes data
Retrieves data from a table
Modifies the structure of a table
Which part of the SELECT query filters records?
ORDER BY
GROUP BY
WHERE
HAVING
What does the UPDATE command do?
Inserts new records
Deletes records
Modifies existing records
Retrieves data
What does the UPDATE command do in SQL?
Retrieves records
Creates tables
Modifies existing records
Deletes data
Why is it important to use WHERE in the UPDATE command?
Improves performance
Creates relationships
Prevents updating all records
Encrypts data
What does the following SQL query do? INSERT INTO Student (name) VALUES ('Ali');
Deletes a student
Updates all students
Inserts a new record
Selects data
What does the following SQL query do? SELECT * FROM Student;
Deletes the table
Updates records
Displays all records
Creates a table
Which SQL command modifies the structure of a table?
SELECT
INSERT
ALTER
UPDATE
SQL is best described as:
Database
Operating system
Language for managing and querying databases
Network protocol
Which device operates at layer 2 of the OSI model?
Router
Modem
Switch
Firewall
What device connects different networks?
Switch
Hub
Router
Network Interface Card (NIC)
What is the main function of DHCP?
Data encryption
Assigning IP addresses to devices on the network
Packet filtering
Routing management
What does DNS do?
Assigns MAC addresses
Encrypts traffic
Converts domain names to IP addresses
Blocks traffic
What does NAT do?
Blocks access to the internet
Assigns MAC addresses
Translates private IP addresses to public IP
Encrypts packets
Which device supports NAT?
Switch
Hub
Router
Modem
Which part of the IP address identifies the host?
Network part
Host part
Subnet mask
MAC address
What is port forwarding?
Blocking ports
Encrypting traffic
Routing traffic to a specific port on a device
Assigning IP addresses
What type of network covers a city or campus?
LAN
PAN
MAN
WAN
Which network has no geographical limitations?
LAN
PAN
MAN
WAN
What does the abbreviation NIC stand for?
Network Internet Connector
Network Internal Card
Network Interface Card
Network Integrated Cable
What model of protocol does the Internet use?
OSI
ISO
TCP/IP
HTTP
Which of the following functions is the primary function of an operating system?
Playing video files
Memory management
Connecting to Wi-Fi
Opening web browsers
What type of kernel is monolithic?
Hybrid kernel
Monolithic kernel
Layered kernel
No kernel
Which interface requires the input of text commands?
Graphical User Interface (GUI)
Command Line Interface (CLI)
Touch Interface
Voice Interface
What is the key difference between booting Windows and Linux?
Windows boots faster
Windows can only boot from the primary partition
Linux cannot boot from USB
A license is required to boot Linux
Which of the following options is an example of system software?
Microsoft Word
Device driver
Google Chrome
Video game
What does the abbreviation GUI stand for?
General User Interface
Graphical User Interface
Global User Interface
Managed User Interaction
What command would you use in Windows to display files in a directory?
ls
dir
list
show
What is the advantage of using CLI compared to GUI?
More colorful interface
Easier for beginners
Faster for repetitive tasks
Requires more memory
Which operating system is open-source?
Windows 11
Ubuntu Linux
macOS
iOS
What does the operating system manage in the context of "process management"?
File locations
Network connections
Allocating the processor to programs
User passwords
Which of the following goals does NOT relate to cybersecurity goals?
Confidentiality
Integrity
Availability
Profitability
What is the difference between authentication and authorization?
They are the same
Authentication confirms identity, authorization confirms access rights
Authentication encrypts data, authorization decrypts it
Authentication is for networks, authorization is for devices
What type of encryption uses only one key?
Symmetric encryption
Asymmetric encryption
Public key encryption
Hashing
What does a digital certificate prove?
Network speed
Data size
Authenticity of the server or user
Cost of the website
What is the main purpose of HTTPS?
Speed up website loading
Block ads
Encrypt data between the browser and the server
Reduce website costs
What type of attack involves the use of fake emails to steal credentials?
Ransomware
Phishing
DDoS
Brute force
What does the term "non-repudiation" mean?
Inability to encrypt data
Inability to access data
Inability to deny the sending of a message or transaction
Inability to alter data
Which of the following options is a physical security measure?
Firewall
Antivirus
Surveillance camera
Password policy
What is the purpose of a digital signature?
To increase the file size
To hide the contents of the file
To verify the authenticity and integrity of the document
To compress data
Which protocol provides encryption for HTTPS?
HTTP
FTP
TLS/SSL
SMTP
What is the Internet?
One computer
Web browser
A network of computer networks around the world
Programming language
What is the World Wide Web?
The same as the hardware of the Internet
Protocol
A collection of websites and web pages
Operating system
What is a web browser?
Network protocol
Search engine
Application that retrieves and displays web pages
Database
What is a URL?
Real name of the computer
Network protocol
Alias used to access a website
IP address
What is an IP address?
Website name
Browser function
Unique numerical identifier of a device on the Internet
Protocol
What does DNS do?
Encrypts data
Sends emails
Converts domain names to IP addresses
Creates web pages
What protocol is the foundation of the World Wide Web?
FTP
TCP
HTTP
DNS
What is HTTPS?
Browser
Insecure protocol
Secure, encrypted version of HTTP
Domain name
What is a hyperlink?
Protocol
Browser
Clickable link to another resource
Server
What is hypertext?
Regular text without links
Encrypted text
Text that contains links to other documents
Text based on IP
What is TCP/IP?
Web browser
Programming language
Set of protocols that enable communication over the Internet
Domain Name System
What happens when you visit a web page?
IP translates DNS
The browser creates a server
DNS converts the URL, the server sends data, the browser displays the page
Data is deleted
What is No-Code AI?
Writing AI models in Python
Using only hardware
Creating AI applications without writing code
Type of operating system
What feature is characteristic of No-Code AI platforms?
Command line interface
Manual coding
Visual interfaces and predefined workflows
Low network speed
Who benefits the most from using No-Code AI?
Only software engineers
Network administrators
Non-technical users
Hardware developers
What task can be performed using No-Code AI?
Writing operating systems
Designing processors
Predictive analytics
Building networks
In which areas is image classification used in No-Code AI?
Only in marketing
Only in medicine
Only in education
In various fields
What does customer segmentation mean?
Data encryption
IP address assignment
Dividing customers into groups based on behavior
Sending emails
In which industry is No-Code AI used for predictive maintenance?
Education
Retail
Manufacturing
Finance
In which field is content generation most commonly used?
Network technologies
Databases
Marketing and advertising
Cybersecurity
Which of the listed platforms is a No-Code AI platform?
Microsoft Word
Google Chrome
Google Teachable Machine
Windows OS
What is the main goal of No-Code AI?
Replace the internet
Make AI more complex
Make AI accessible without programming
Remove databases
What is a block in a blockchain?
A unit of data storage linked to other blocks
A program for encrypting data
A server for storing information
A network for transmitting data
What is a block in a blockchain?
Computer
Protocol
Container that stores transactions
Network cable
What connects blocks together in a blockchain?
Passwords
IP addresses
Hash pointers
MAC addresses
What will happen if the data in the block changes?
Nothing will happen
Only this block will change
The hash will change and the chain will be broken
The node will restart
What is immutability?
Fast transactions
Encryption
Data cannot be changed after being added
Centralized control
What is a node?
Computer
Protocol
Container that stores transactions
Network cable
What is a node in a blockchain network?
User
Transaction
Computer participating in the blockchain network
Wallet password
What is the architecture of a blockchain network?
Client-server
Centralized
Peer-to-peer (P2P)
Star topology
What does decentralization mean?
One central authority
Faster internet
Absence of a single governing entity
Private access
What feature makes blockchain resistant to forgery?
Firewalls
Central servers
Blocks linked by hashes
User accounts
