A scientist collects temperature readings, satellite images, and audio recordings of bird calls
for a climate study. Collectively, what are these items called? - ANSWER Data
A vinyl record stores music as continuous grooves, while a music file on a phone stores it as a
series of discrete numbers (0s and 1s). This represents the difference between which two
data formats? - ANSWER Analog and Digital
An online store organizes all its product information, including names, prices, and quantities,
into a set of structured tables for easy retrieval and management. What is this organized col-
lection called? - ANSWER A database
What is the primary role of a Database Management System (DBMS)? - ANSWER To act
as the software that manages and controls access to a database
An analyst uses the command "SELECT Name FROM Customers WHERE City = 'London';" to
get a list of customer names. The command itself is an example of what? - ANSWER A
query
A bank customer wants to check their account balance. They open a mobile app on their
phone and tap a "View Balance" button. What component did the customer interact with di-
rectly? - ANSWER The database application
A data breach occurred at a company. The person responsible for investigating, determining
who had access to what data, and securing the system against future attacks holds which da-
tabase role? - ANSWER Database Administrator
1
,Before any data is stored, a person is tasked with defining the structure of the database, in-
cluding all tables, columns, and the relationships between them. What is this person's role? -
ANSWER Database Designer
A software developer is writing Python code that will connect to a database to retrieve and
display user information. Which role is this developer performing? - ANSWER Database
Programmer
A small business tracks its inventory in a single spreadsheet. As the business grows, they find
that multiple employees editing the file at once leads to errors and corrupted data. A DBMS
is better suited for this situation primarily because it can handle: - ANSWER Complex re-
quirements
A manager should only be able to see the salary information for employees in their own de-
partment. The DBMS feature that controls this is called: - ANSWER Authorization
When you purchase a movie ticket online, the system must both reserve your seat and pro-
cess your payment. If either step fails, the entire operation must be canceled. This all-or-
nothing principle describes a: - ANSWER Transaction
Imagine a transaction to transfer $100 from Account A to Account B. If the system crashes
after successfully debiting $100 from Account A but before crediting Account B, what should
the DBMS do upon restarting? - ANSWER Roll back the transaction, returning the $100
to Account A
When you submit an SQL query, which internal component of the DBMS parses the query,
checks it for correctness, and determines the most efficient way to access the data? - AN-
SWER Query Processor
In a DBMS, which component is responsible for reading and writing data on the physical
disk? - ANSWER The Storage Manager
2
,To execute a query, the query processor needs information about the tables, columns, and
indexes in the database. Where does it find this metadata? - ANSWER The Database Cat-
alog
A sudden power outage corrupts a database. The Database Administrator uses the transac-
tion log to undo incomplete transactions and restore the database to a consistent state. This
process is known as: - ANSWER Recovery
What is the defining characteristic of a relational database? - ANSWER Data is organized
into tables that consist of rows and columns
A developer is building an application with rapidly changing data requirements and large
amounts of unstructured data. Which type of database would be most suitable? - AN-
SWER NoSQL Database
A company chooses to use PostgreSQL, a database whose source code is freely available for
anyone to view, modify, and distribute. This type of software license is known as: - AN-
SWER Open Source
A startup is looking for a powerful relational database that requires no initial licensing fees
and allows their developers to view the source code. Which of the following systems best
fits their need for an open-source license? - ANSWER PostgreSQL
An application needs to add a new customer to a Customers table. Which CRUD operation
does this represent? - ANSWER Create
Which language is the international standard for querying and manipulating data in rela-
tional databases? - ANSWER SQL
When creating a table in SQL, what is the purpose of specifying a data type like DECIMAL(8,
2) for a Price column? - ANSWER It defines that the column can hold numbers with a to-
tal of 8 digits, with 2 of those digits after the decimal point
3
, The acronym CRUD describes the four fundamental operations in a database. What do the
letters stand for? - ANSWER Create, Read, Update, Delete
What are the three primary phases of the database design process, in the correct order? -
ANSWER Conceptual, Logical, Physical
In a standard Entity-Relationship (ER) diagram, what is the primary purpose of rectangles? -
ANSWER To represent the entities
What is the main goal of the conceptual design phase? - ANSWER To understand and
document the business requirements and high-level data entities
What is a database schema? - ANSWER The formal blueprint of a database, defining its
structure, tables, and relationships
The process of deciding to create an index on a frequently searched column belongs to
which design phase? - ANSWER Physical design
What is the principle of data independence in database design? - ANSWER Changes can
be made to the internal structure of the database without affecting the external view of the
data
What is the purpose of a database API (Application Programming Interface), such as JDBC or
ODBC? - ANSWER It provides a standard way for application code to communicate with a
database, regardless of the specific database vendor
A formal database model is a framework that specifies which three components? - AN-
SWER Data Structures, Operations, and Integrity Rules
4
for a climate study. Collectively, what are these items called? - ANSWER Data
A vinyl record stores music as continuous grooves, while a music file on a phone stores it as a
series of discrete numbers (0s and 1s). This represents the difference between which two
data formats? - ANSWER Analog and Digital
An online store organizes all its product information, including names, prices, and quantities,
into a set of structured tables for easy retrieval and management. What is this organized col-
lection called? - ANSWER A database
What is the primary role of a Database Management System (DBMS)? - ANSWER To act
as the software that manages and controls access to a database
An analyst uses the command "SELECT Name FROM Customers WHERE City = 'London';" to
get a list of customer names. The command itself is an example of what? - ANSWER A
query
A bank customer wants to check their account balance. They open a mobile app on their
phone and tap a "View Balance" button. What component did the customer interact with di-
rectly? - ANSWER The database application
A data breach occurred at a company. The person responsible for investigating, determining
who had access to what data, and securing the system against future attacks holds which da-
tabase role? - ANSWER Database Administrator
1
,Before any data is stored, a person is tasked with defining the structure of the database, in-
cluding all tables, columns, and the relationships between them. What is this person's role? -
ANSWER Database Designer
A software developer is writing Python code that will connect to a database to retrieve and
display user information. Which role is this developer performing? - ANSWER Database
Programmer
A small business tracks its inventory in a single spreadsheet. As the business grows, they find
that multiple employees editing the file at once leads to errors and corrupted data. A DBMS
is better suited for this situation primarily because it can handle: - ANSWER Complex re-
quirements
A manager should only be able to see the salary information for employees in their own de-
partment. The DBMS feature that controls this is called: - ANSWER Authorization
When you purchase a movie ticket online, the system must both reserve your seat and pro-
cess your payment. If either step fails, the entire operation must be canceled. This all-or-
nothing principle describes a: - ANSWER Transaction
Imagine a transaction to transfer $100 from Account A to Account B. If the system crashes
after successfully debiting $100 from Account A but before crediting Account B, what should
the DBMS do upon restarting? - ANSWER Roll back the transaction, returning the $100
to Account A
When you submit an SQL query, which internal component of the DBMS parses the query,
checks it for correctness, and determines the most efficient way to access the data? - AN-
SWER Query Processor
In a DBMS, which component is responsible for reading and writing data on the physical
disk? - ANSWER The Storage Manager
2
,To execute a query, the query processor needs information about the tables, columns, and
indexes in the database. Where does it find this metadata? - ANSWER The Database Cat-
alog
A sudden power outage corrupts a database. The Database Administrator uses the transac-
tion log to undo incomplete transactions and restore the database to a consistent state. This
process is known as: - ANSWER Recovery
What is the defining characteristic of a relational database? - ANSWER Data is organized
into tables that consist of rows and columns
A developer is building an application with rapidly changing data requirements and large
amounts of unstructured data. Which type of database would be most suitable? - AN-
SWER NoSQL Database
A company chooses to use PostgreSQL, a database whose source code is freely available for
anyone to view, modify, and distribute. This type of software license is known as: - AN-
SWER Open Source
A startup is looking for a powerful relational database that requires no initial licensing fees
and allows their developers to view the source code. Which of the following systems best
fits their need for an open-source license? - ANSWER PostgreSQL
An application needs to add a new customer to a Customers table. Which CRUD operation
does this represent? - ANSWER Create
Which language is the international standard for querying and manipulating data in rela-
tional databases? - ANSWER SQL
When creating a table in SQL, what is the purpose of specifying a data type like DECIMAL(8,
2) for a Price column? - ANSWER It defines that the column can hold numbers with a to-
tal of 8 digits, with 2 of those digits after the decimal point
3
, The acronym CRUD describes the four fundamental operations in a database. What do the
letters stand for? - ANSWER Create, Read, Update, Delete
What are the three primary phases of the database design process, in the correct order? -
ANSWER Conceptual, Logical, Physical
In a standard Entity-Relationship (ER) diagram, what is the primary purpose of rectangles? -
ANSWER To represent the entities
What is the main goal of the conceptual design phase? - ANSWER To understand and
document the business requirements and high-level data entities
What is a database schema? - ANSWER The formal blueprint of a database, defining its
structure, tables, and relationships
The process of deciding to create an index on a frequently searched column belongs to
which design phase? - ANSWER Physical design
What is the principle of data independence in database design? - ANSWER Changes can
be made to the internal structure of the database without affecting the external view of the
data
What is the purpose of a database API (Application Programming Interface), such as JDBC or
ODBC? - ANSWER It provides a standard way for application code to communicate with a
database, regardless of the specific database vendor
A formal database model is a framework that specifies which three components? - AN-
SWER Data Structures, Operations, and Integrity Rules
4
