Font size
WorksheetsIT Fundamentals: Basic Concepts
Total questions: 85
Worksheet time: 45mins
Which of the following is a string?
451
99,999
True
"Hello World"
What format uses four sets of numbers with periods between them to represent an IP address?
Hexadecimal notation
Binary notation
Dotted decimal notation
Octal notation
What is one advantage of using a wired mouse over a wireless mouse?
It is more expensive
It requires batteries
It does not need to be charged separately
It needs to be charged separately
Which word processing software is free and looks a lot like Microsoft Word?
Google Docs
LibreOffice Writer
Apple's Pages
Microsoft Word
Which of the following is a sign of a potentially fake email?
The email has a professional tone.
The email contains spelling or grammar mistakes.
The email addresses you by name.
The email is from a known company.
What should you consider as you grow in your IT career?
The salary only
What you've experienced and what you prefer
The location of the job
The company's reputation
What is one advantage of using multiple guest OSs on a single physical computer?
They can share the same virus protection
They can perform different tasks independently
They require less memory
They are easier to install
How can individuals monetize their own data?
By selling it directly to data brokers
By participating in surveys
By creating websites
By downloading apps
Why is it important to review the privacy policy of a social media platform?
To find out how to report a post
To understand how your data is used
To learn new posting techniques
To see how to deactivate your account
Why is the Internet described as a decentralized system?
There is one central authority that controls the Internet
No single person or group controls the entire Internet
The Internet is only accessible in certain countries
The Internet relies on a single, central server for all data
Why is the Internet described as a decentralized system?
There is one central authority that controls the Internet
No single person or group controls the entire Internet
The Internet is only accessible in certain countries
The Internet relies on a single, central server for all data
What is a common use of spreadsheets in the modern world?
Designing websites
Statistical analysis and financial information
Creating presentations
Writing essays
What is cloud storage?
A method of storing data on your local computer
A service that allows you to store data on remote servers accessed via the Internet
A type of physical storage device like a USB drive
A software application for creating documents
Where can you view device drivers in Windows?
Control Panel
Task Manager
Device Manager
File Explorer
What is the weak link in a network?
The fastest part of the network
The slowest part of the network
The most expensive part of the network
The newest part of the network
Which of the following correctly defines a database record?
A single piece of information in a database
A collection of related fields in a row
A column in a table
A summary of data
What is a soft robot?
A robot designed to handle delicate items gently with flexible materials
A robot that is used exclusively in the automotive industry
A robot that can only operate in water
A robot that is powered by solar energy
What does 1 Hertz (Hz) mean?
One cycle per minute
One cycle per second
One cycle per hour
One cycle per millisecond
If condition A is True and condition B is False, what does the OR operation return?
True
False
True and False
Neither True nor False
What is a Storage Area Network (SAN)?
A way to store files in the cloud
A separate subnetworks consisting of storage devices and servers
A type of software for managing files
A network design to connect different LANs
In pseudocode, what does the symbol || represent?
Logical AND
Logical OR
Logical XOR
Logical NOT
What is the main reason AI has started to take off in recent years?
Better computer hardware
More human programmers
Increased internet speeds
More data storage options
Who created the first computer program?
Charles Babbage
Alan Turing
Ada Lovelace
Bill Gates
Why are constraints important in a database?
They allow for more tables to be created.
They prevent data inconsistency.
They make the database run faster.
They allow fields to be left blank.
What is the first software to run when a computing device starts up?
Operating System
BIOS/UEFI
Antivirus Software
Internet Browser
How do computers use binary to represent information?
By using combinations of digits 0 through 9
By using combinations of only two values 0 and 1
By using combinations of letters A through F
By using combinations of symbols and characters
What is one of the first things you should do if your browser is behaving strangely?
Check your internet connection
Clear your browser’s cache
Install a new antivirus program
Delete all your bookmarks
After changing the signal, where does the modem send the signal?
To the computer
To the router
To the ISP
To the nearest cell tower
Which of the following lists two interpreted languages?
Python and C++
JavaScript and Ruby
Java and Perl
C# and Bash
What is the main advantage of using a passphrase over a traditional password?
Easier to forget
Shorter in length
Easier to remember and more secure
More difficult to type
What does the Modify permission allow a user to do?
Only read files
Read and write files, and delete folders
Only execute files
Only list file contents
What type of relationship has one record with a primary key associated with multiple records in other tables with foreign keys?
One-to-one relationship
One-to-many relationship
Many-to-one relationship
Many-to-many relationship
What happens when you delete an application from within Settings on a Windows computer?
It goes to the Recycle Bin.
It is permanently deleted.
It moves to a temporary folder.
It gets archived.
What is the easiest way to add Wi-Fi to a desktop computer that doesn’t have it built-in?
Install a new operating system
Use a USB wireless adapter
Replace the motherboard
Connect an Ethernet cable
What unit is used to measure latency?
Kilobytes (KB)
Megabits per second (Mbps)
Milliseconds (ms)
Gigabytes (GB)
What type of files can a document database store?
Only text files
Only image files
Many different types of files
Only video files
What is heuristic identification in antivirus software?
Using a list of known virus patterns
Looking for actions or behaviors similar to what viruses do
Scanning files only when you manually start it
Constantly updating virus definitions
What type of hypervisor is needed to use virtualization on an existing OS?
Type I hypervisor
Type II hypervisor
Cloud hypervisor
Network hypervisor
What is real-time scanning in antivirus software?
Scanning all files when manually started
Constantly watching your computer for threats
Scanning when the computer is not being used
Scanning the system during the system startup
What is ciphertext?
Text that has been encrypted
Text that has been deleted
Text that is written in code
Text that has been printed
Which key combination can be used to open Task Manager?
Ctrl + Shift + Alt
Ctrl + Alt + Delete
Alt + F4
Windows + R
Which spreadsheet software is known for its powerful macro language to automate tasks?
Google Sheets
LibreOffice Calc
Microsoft Excel
Apple Numbers
Which numbering system is used to represent file permissions in Linux?
Binary
Decimal
Octal
Hexadecimal
What is the main limitation of the ASCII format?
It can only represent numbers
It is too complex to use
It only supports 128 characters, primarily based on the English language
It is incompatible with modern computers
Why is it important to be cautious with personal details that seem harmless on the Internet?
They can lead to personalized advertising.
They can be combined to create a complete profile of your identity.
They are necessary for creating strong passwords.
They can make your social media profiles more interesting.
What is the purpose of video memory in a GPU?
To store the operating system
To process picture information quickly
To cool the GPU
To connect multiple monitors
Which cloud service model is best for businesses that want to save money and time by not handling physical servers themselves?
Software as a Service (SaaS)
Platform as a Service (PaaS)
Infrastructure as a Service (IaaS)
On-premises management
What is a web application firewall used for?
Protecting email servers
Filtering and monitoring traffic between a web application and the Internet
Preventing unauthorized access to a network
Storing web application data
What is the main purpose of pseudocode?
To write the final code for a program
To describe what the code will do using plain language
To create a user interface for the program
To compile the program into machine language
What does a system backup usually involve?
Copying some folders to an external hard drive
Creating a fully bootable disk image
Deleting unnecessary files
Installing the latest software updates
Why do modern developers not work directly with machine language?
It is too slow.
It is too expensive.
It is very hard to understand.
It is outdated.
What does the New Technology File System (NTFS) do in Windows?
It organizes files and folders on storage media.
It plays multimedia files.
It is the replacement for File Explorer.
It is a file manager with built-in malware protection.
Why is encrypting data at rest sometimes more complicated than encrypting data in transit?
Because it requires more storage space
Because the encryption keys must be kept secure for a longer period of time
Because it needs more powerful computers
Why are key-value databases useful for tasks that need quick data access?
They use complex data models
They have a flexible structure
They are difficult to understand
They cannot grow quickly
Why is it important to back up personal data files?
They take up too much space on the computer
They are difficult or impossible to recreate
They can be easily downloaded again
They are not important
How can the method of starting at one end of the system help?
It ensures a systematic and thorough check of all components
It always slows the process and wastes time
It focuses only on software issues
It immediately identifies the problem without testing
Why is code written in assembly language more efficient?
It uses a compiler.
It is written in binary.
It allows direct access to hardware.
It is a high-level language.
What is proprietary software?
Software that is free to use and modify.
Software that is made by companies and sold for profit.
Software that is only used in schools.
Software that is always free of charge.
What is the difference between LGA and PGA designs in CPUs?
LGA has pins, and PGA has pads
LGA has pads, and PGA has pins
LGA is used by AMD, and PGA is used by Intel
LGA is slower than PGA
What is a Kensington lock used for?
Encrypting data
Locking a laptop to prevent theft
Monitoring network traffic
Installing software updates
How do SANs typically connect to ensure fast data transfer?
Through Wi-Fi
Using fiber cables
Via Bluetooth
Through USB cables
What type of memory is the UEFI stored on?
RAM
ROM
Hard Drive
SSD
What is a user's profile on a computer?
The main system folder
The environment set up for a specific user
The list of installed programs
The computer's hardware configuration
What is one reason mobile apps are designed differently from computer software?
Mobile devices have smaller touchscreens
Mobile devices are more powerful
Mobile devices use different programming languages
Mobile devices do not need software updates
Which motherboard connection is commonly used with M.2 SSDs?
USB
PCIe
SATA
Ethernet
What technology helps reduce the number of cords around computers?
Mechanical switches
Wired connections
Wireless technology
Ergonomic designs
What is a soft robot?
A robot designed to handle delicate items gently with flexible materials
A robot that is used exclusively in the automotive industry
A robot that can only operate in water
A robot that is powered by solar energy
What does "Integrity" in the CIA Triad guarantee?
Information is only accessible to authorized users
Information is stored and transferred as intended
Information is readily available
Information cannot be denied by its creator
What is a square wave in the context of a computer's clock signal?
A signal that gradually increases and decreases in voltage like a sine wave
A digital signal that alternates sharply between high and low levels
A constant high voltage signal with no variation
An analog signal used only for audio output
Because it involves more complex algorithms
A type of sound wave
A wave that represents binary digits
A wave that measures temperature
A wave that measures light intensity
What is the main difference between the Internet and the World Wide Web (WWW)?
The Internet is a collection of servers, while the WWW is a network of computers.
The Internet is a huge network of computers, while the WWW is a collection of interconnected files that use the Internet to share content.
The Internet is used for emails, while the WWW is used for social media.
The Internet is only accessible through mobile devices, while the WWW is accessible through computers.
What is the main advantage of HDMI over older connections like VGA?
HDMI can carry both audio and video.
HDMI is cheaper to produce.
HDMI cables are shorter.
HDMI is only used for TVs.
What is a significant advantage of Apple’s CPUs mentioned in the text?
They are cheaper than other CPUs
They have built-in memory
They are made by Intel
They use more power
How do enterprise APs typically connect to the main network?
Using Wi‑Fi signals
Using Bluetooth
Using an Ethernet cable
Using a USB cable
What is the purpose of the 24-pin power connector on a motherboard?
To connect the keyboard and mouse
To provide power from the power supply to all connected parts
To connect the monitor
To store temporary data
What is the base of the hexadecimal numbering system?
2
8
10
16
What is a database?
A place to store physical items
A highly organized, multi-table digital storage system
A type of computer game
A social media platform
What does forced data entry mean in the context of databases?
Forcing users to enter data quickly.
Controlling and validating the information users enter.
Forcing users to use specific software.
Forcing users to back up their data.
Which type of cable is most commonly used in wired networks?
Coaxial cable
Ethernet cable
Fiber optic cable
USB cable
Which of the following is a valid filename?
report?.docx
data*2023.xlsx
summary report.pdf
project_report.docx
What does the term processing speed refer to?
How fast a computer can connect to the internet
How fast a computer performs a given operation or task
How fast a computer can download files
How fast a computer can display images
What is a flat file system?
A type of database.
Another name for a spreadsheet.
A way to store images.
A method to back up data.
Where do deleted files go in Windows before they are permanently removed?
Trash
Recycle Bin
Temp folder
System32 folder
What is a flat file system?
A type of database.
Another name for a spreadsheet.
A way to store images.
A method to back up data.
