NEW
Font size
Worksheets2nd Nine Weeks Review (CertMaster 8.0-9.0)
Total questions: 49
Worksheet time: 25mins
What is one reason organizations prefer databases over spreadsheets?
Databases can generate colorful graphs.
Databases can handle more data points efficiently.
Spreadsheets are harder to understand.
Spreadsheets are only for financial reports.
What is a UPS?
A device that stores data off-site
A battery-powered device that supplies AC power during a power failure
A type of security system
A device that increases internet speed
Which type of data is best stored in a relational database?
Non-structured data
Semi-structured data
Structured data
Random data
Why are databases important for businesses?
They help in organizing physical files.
They allow businesses to make smart choices and plan for the future.
They provide a list of all installed software.
They only work in the cloud.
What is a data center?
A place where you can buy computers
A dedicated location that holds thousands of servers
A type of computer virus
A software used to store data
What type of printer creates three-dimensional objects?
Laser Printer
Inkjet Printer
3D Printer
Thermal Printer
What is the primary function of a motherboard in a computer?
To store data permanently
To link all the parts together and send electrical signals between them
To provide internet connectivity
To display images on the screen
What is non-structured data?
Data that fits neatly into rows and columns
Data that doesn't have a clear order or pattern
Data that is always numerical
Data that is always textual
What does scalability in a database mean?
The ability to store physical items
The ability to handle a large amount of data efficiently
The process of adding more physical hard drives for data storage
The ability to access social media
What is the primary function of a network interface card (NIC)?
To store data
To connect a computer to a network
To display graphics
To play sound
What can the value in a key-value pair be?
Only numbers
Only words
Any type of data
Only dates
What technology allows a smartphone to send a signal to a projector or TV wirelessly?
USB-C
HDMI
Casting
VGA
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 does a key in a key-value database represent?
A unique identifier
A type of data
A table
A column
What is the purpose of forms in a database?
To create new tables
To reduce data entry errors
To delete records
To change database settings
Why is it difficult to increase CPU speeds beyond current levels?
It requires more internet bandwidth.
It generates too much heat.
It needs more storage space.
It consumes too much electricity.
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 one benefit of cloud storage?
It is always free
It can expand or contract based on your needs
It never requires an Internet connection
It is only available for businesses
What is a key advantage of Hard Disk Drives (HDDs) over Solid State Drives (SSDs) in terms of storage size?
HDDs can store more data than SSDs.
HDDs are faster than SSDs.
HDDs are more portable than SSDs.
HDDs use less power than SSDs.
What does hot-swappable mean for USB devices?
You can add or remove them while the system is running.
You need to restart the system to add or remove them.
They generate a lot of heat.
They are only compatible with certain operating systems.
Which type of connector is becoming most common for new and high-quality devices?
USB Type A
USB Type B
USB Type B-Micro
USB Type C
What does a higher resolution in video output mean?
More pixels and better image details
Faster processing speed
Lower power consumption
Smaller screen size
What is a database schema?
A) A type of software
B) The architecture of how a database is structured and organized
C) A programming language
D) A type of data storage device
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
What is a primary key in a database?
A unique identifier for each record
A common name shared by multiple records
A type of data that can be left blank
A value that can change over time
What is the purpose of cache memory in a CPU?
To store the operating system
To store frequently used data for quick access
To increase the clock speed
To cool the CPU
Why are databases better for concurrent use compared to spreadsheets?
Databases are cheaper.
Databases allow many users to access data simultaneously.
Spreadsheets cannot store words.
Spreadsheets are only for single users.
What does throughput measure?
The highest amount of data a network can handle at once
How much data moves through a system in one second
The total storage capacity of a computer
The number of devices connected to a network
What does 1 Hertz (Hz) mean?
One cycle per minute
One cycle per second
One cycle per hour
One cycle per millisecond
What is the main function of a projector when connected to a computer?
To extend your desktop so you have more workspace
To display the computer screen to a larger audience
To remotely share presentations
To share videos over the internet
What is the primary purpose of a SAN?
To create an off-site backup
To store and manage files in one location
To safely backup individual machines
To manage storage for different WANs
What is one way cloud storage can help with collaboration?
It makes files impossible to share.
It allows you to share files and set permissions.
It is less secure so anyone can access the files.
It only allows viewing of files.
What data formats are commonly used in document databases?
CSV and TXT
JSON and XML
DOC and PDF
HTML and CSS
What is a Network Attached Storage (NAS)?
A) A type of smartphone
B) A storage device connected to a local area network
C) A type of printer
D) A software application for editing photos
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
Which term describes the small wires that connect the areas of a motherboard?
Socket
Port
Slot
Bus
What technology allows some printers to scan an image and turn it into an editable document?
ADF
OCR
USB
Wi-Fi
What are the two main types of printers?
Laser and Dot Matrix
Inkjet and Thermal
Laser and Inkjet
Thermal and Dot Matrix
What does Mbps stand for?
Megabytes per second
Megabits per second
Millibits per second
Microbits per second
What is the main function of the BIOS or UEFI when a computer is powered on?
Load the operating system
Check the hardware components
Run antivirus software
Connect to the internet
What should you be cautious of when downloading drivers from websites other than the manufacturer's?
Slow download speeds
Corrupt software or malware
High costs
Long installation times
What is the main reason storage drives are not used instead of RAM for active processes?
They are too expensive.
They are too slow.
They are too small.
They are too complex.
What does a relationship in a database do?
Stores data
Connects two entities
Deletes data
Creates a new database
Which protocol was created for transferring data to and from SSDs?
USB
NVMe
HDMI
Ethernet
What is the best way to enter large amounts of data into a database?
Typing it in manually
Importing it from other sources
Printing and scanning the information
Using a word processor
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 field?
A single piece of information in a database
A collection of related fields in a row
A summary of data
A request for data from the database
What does 1 Megahertz (MHz) represent?
1 thousand cycles per second
1 million cycles per second
1 billion cycles per second
1 trillion cycles per second
What is a foreign key?
A key that is used to unlock a database
A primary key from another table
A key that can be left blank
A key that is always the same as the primary key
