D426 - Section Quizes(TEST BANK)
A scientist collects temperature readings, satellite images, Data
audio recordings of bird calls for a climate study.
and 3 multiple choice options
Collectively, what are these items called?
A vinyl record stores music as continuous grooves, while a Analog and
Digital music file on a phone stores it as a series of discrete 3
numbers (0s and 1s). This represents the difference
multiple choice options
between which two data formats?
An online store organizes all its product information, A database
including names, prices, and quantities, into a set of 3 multiple choice options
structured tables for easy retrieval and management.
What is this organized collection called?
What is the primary role of a Database Management To act as the software that manages and controls access to a
System (DBMS)?
database 3 multiple choice options
An analyst uses the command "SELECT Name FROM A query
WHERE City = 'London';" to get a list of
Customers 3 multiple choice options
customer names. The command itself is an example of
what?
A bank customer wants to check their account balance. The database application
They open a mobile app on their phone and tap a "View 3 multiple choice options
Balance" button. What component did the customer
interact with directly?
, A data breach occurred at a company. The person Database
Administrator responsible for investigating, determining who had access
3 multiple choice options
to what data, and securing the system against future
attacks holds which database role?
Before any data is stored, a person is tasked with defining Database
Designer the structure of the database, including all tables, 3
columns, and the relationships between them. What is this
multiple choice options
person's role?
A software developer is writing Python code that will Database Programmer
connect to a database to retrieve and display user 3 multiple choice options
information. Which role is this developer performing?
A small business tracks its inventory in a single Complex
requirements spreadsheet. As the business grows, they find that multiple
3 multiple choice options
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:
A manager should only be able to see the salary Authorization
information for employees in their own department. The 3 multiple choice options
DBMS feature that controls this is called:
When you purchase a movie ticket online, the system Transaction
both reserve your seat and process your payment. If
must 3 multiple choice options
either step fails, the entire operation must be
canceled. This all-or-nothing principle describes a:
Imagine a transaction to transfer $100 from Account A to Roll back the transaction, returning the $100 to
Account A Account B. If the system crashes after successfully
3 multiple choice options
debiting $100 from Account A but before crediting
Account B, what should the DBMS do upon restarting?
When you submit an SQL query, which internal Query Processor
component of the DBMS parses the query, checks it for 3 multiple choice options
correctness, and determines the most efficient way to
access the data?
In a DBMS, which component is responsible for reading The Storage Manager
and writing data on the physical disk? 3 multiple choice options
To execute a query, the query processor needs The Database Catalog
information about the tables, columns, and indexes in the 3 multiple choice
database. Where does it find this metadata?
options
A sudden power outage corrupts a database. The Recovery
Administrator uses the transaction log to undo
Database 3 multiple choice options
incomplete transactions and restore the database to a
consistent state. This process is known as:
A scientist collects temperature readings, satellite images, Data
audio recordings of bird calls for a climate study.
and 3 multiple choice options
Collectively, what are these items called?
A vinyl record stores music as continuous grooves, while a Analog and
Digital music file on a phone stores it as a series of discrete 3
numbers (0s and 1s). This represents the difference
multiple choice options
between which two data formats?
An online store organizes all its product information, A database
including names, prices, and quantities, into a set of 3 multiple choice options
structured tables for easy retrieval and management.
What is this organized collection called?
What is the primary role of a Database Management To act as the software that manages and controls access to a
System (DBMS)?
database 3 multiple choice options
An analyst uses the command "SELECT Name FROM A query
WHERE City = 'London';" to get a list of
Customers 3 multiple choice options
customer names. The command itself is an example of
what?
A bank customer wants to check their account balance. The database application
They open a mobile app on their phone and tap a "View 3 multiple choice options
Balance" button. What component did the customer
interact with directly?
, A data breach occurred at a company. The person Database
Administrator responsible for investigating, determining who had access
3 multiple choice options
to what data, and securing the system against future
attacks holds which database role?
Before any data is stored, a person is tasked with defining Database
Designer the structure of the database, including all tables, 3
columns, and the relationships between them. What is this
multiple choice options
person's role?
A software developer is writing Python code that will Database Programmer
connect to a database to retrieve and display user 3 multiple choice options
information. Which role is this developer performing?
A small business tracks its inventory in a single Complex
requirements spreadsheet. As the business grows, they find that multiple
3 multiple choice options
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:
A manager should only be able to see the salary Authorization
information for employees in their own department. The 3 multiple choice options
DBMS feature that controls this is called:
When you purchase a movie ticket online, the system Transaction
both reserve your seat and process your payment. If
must 3 multiple choice options
either step fails, the entire operation must be
canceled. This all-or-nothing principle describes a:
Imagine a transaction to transfer $100 from Account A to Roll back the transaction, returning the $100 to
Account A Account B. If the system crashes after successfully
3 multiple choice options
debiting $100 from Account A but before crediting
Account B, what should the DBMS do upon restarting?
When you submit an SQL query, which internal Query Processor
component of the DBMS parses the query, checks it for 3 multiple choice options
correctness, and determines the most efficient way to
access the data?
In a DBMS, which component is responsible for reading The Storage Manager
and writing data on the physical disk? 3 multiple choice options
To execute a query, the query processor needs The Database Catalog
information about the tables, columns, and indexes in the 3 multiple choice
database. Where does it find this metadata?
options
A sudden power outage corrupts a database. The Recovery
Administrator uses the transaction log to undo
Database 3 multiple choice options
incomplete transactions and restore the database to a
consistent state. This process is known as:
