WorksheetsDatabase
Total questions: 20
Worksheet time: 10mins
What is a database?
A physical storage device.
A collection of unorganized data.
An organized collection of data.
A programming language.
Which of the following is responsible for managing an organization's database?
Data analyst
Database administrator (DBA)
Network engineer
Software developer
What is the smallest unit of data in the hierarchy of data?
Byte
Bit
Field
Record
Which of the following is NOT part of the hierarchy of data?
Bit
Field
Program
Database
What does a DBMS (Database Management System) do?
Physically stores data.
Provides an interface for users and applications to interact with a database.
Translates programming languages.
Prevents unauthorized access to the Internet.
Which of the following describes a primary key?
A field used to identify a record uniquely.
A field that stores encrypted data.
A backup copy of a database.
A method of querying a database.
In a relational database, what is a table row called?
Attribute
Schema
Field
Record
Which of the following is an example of a popular DBMS for multiple users?
Microsoft Access
FileMaker Pro
Oracle
Excel
What is the main function of data centers?
Housing database servers and delivering mission-critical information.
Storing physical documents.
Creating software applications.
Managing social media accounts.
What is an entity in a database?
A backup file.
A program used to manage data.
A general class of people, places, or things for which data is collected.
A type of database software.
Which database model organizes data into tables where each row represents an entity?
Hierarchical model
Object-oriented model
Relational model
Network model
Which of the following SQL commands is used to retrieve data from a database?
DELETE
INSERT
UPDATE
SELECT
What is the purpose of a data warehouse?
To store website files
To manage software development
To hold business information from multiple sources for decision-making
To act as a temporary data backup
What is data mining primarily used for?
Protecting database security
Managing network connections
Discovering patterns and relationships in data
Encrypting sensitive information
Which of the following describes a replicated database?
A database stored on a single machine.
A duplicate set of frequently used data.
A database managed entirely by a third party.
A backup of a deleted database.
What is the primary goal of Business Intelligence (BI)?
To replace database management systems.
To create relational database tables.
To eliminate data redundancy.
To gather, analyze, and use data for strategic decision-making.
Which of the following correctly represents the hierarchy of data?
Characters → Files → Fields → Databases → Records
Bits → Characters → Fields → Records → Files → Databases
Files → Databases → Bits → Fields → Records
Fields → Bits → Characters → Files → Databases
Which type of database allows multiple users to access it at the same time?
Single-user database
Flat-file database
Distributed database
Object-oriented database
Data modeling helps organizations to:
Reduce database costs.
Plan and structure their data.
Eliminate the need for databases
Store data in physical servers only
The purpose of indexing in a database is to:
Improve search and retrieval speed.
Store backup copies.
Encrypt all data.
Prevent unauthorized access.
