D426 - Section Quizes
Compilation Flashcards
(2025-2026)
Question and Answers
Expert Verified
(With A+ Grades Guarantee)
,A scientist collects temperature readings, satellite images, Data
and audio recordings of bird calls for a climate study. 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 multiple choice options
numbers (0s and 1s). This represents the difference
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 database
System (DBMS)? 3 multiple choice options
An analyst uses the command "SELECT Name FROM A query
Customers WHERE City = 'London';" to get a list of 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, columns, 3 multiple choice options
and the relationships between them. What is this 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 must Transaction
both reserve your seat and process your payment. If either 3 multiple choice options
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 component Query Processor
of the DBMS parses the query, checks it for correctness, 3 multiple choice options
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 information The Database Catalog
about the tables, columns, and indexes in the database. 3 multiple choice options
Where does it find this metadata?
A sudden power outage corrupts a database. The Recovery
Database Administrator uses the transaction log to undo 3 multiple choice options
incomplete transactions and restore the database to a
consistent state. This process is known as:
What is the defining characteristic of a relational Data is organized into tables that consist of rows and columns
database? 3 multiple choice options
A developer is building an application with rapidly changing NoSQL Database
data requirements and large amounts of unstructured data. 3 multiple choice options
Which type of database would be most suitable?
A company chooses to use PostgreSQL, a database Open Source
whose source code is freely available for anyone to view, 3 multiple choice options
modify, and distribute. This type of software license is
known as:
A startup is looking for a powerful relational database that PostgreSQL
requires no initial licensing fees and allows their 3 multiple choice options
developers to view the source code. Which of the following
systems best fits their need for an open-source license?
An application needs to add a new customer to a Create
Customers table. Which CRUD operation does this 3 multiple choice options
represent?
Which language is the international standard for querying SQL
and manipulating data in relational databases? 3 multiple choice options
When creating a table in SQL, what is the purpose of It defines that the column can hold numbers with a total of 8 digits, with 2 of those
specifying a data type like DECIMAL(8, 2) for a Price digits after the decimal point
column? 3 multiple choice options
The acronym CRUD describes the four fundamental Create, Read, Update, Delete
operations in a database. What do the letters stand for? 3 multiple choice options
What are the three primary phases of the database design Conceptual, Logical, Physical
process, in the correct order? 3 multiple choice options
In a standard Entity-Relationship (ER) diagram, what is the To represent the entities
primary purpose of rectangles? 3 multiple choice options
Compilation Flashcards
(2025-2026)
Question and Answers
Expert Verified
(With A+ Grades Guarantee)
,A scientist collects temperature readings, satellite images, Data
and audio recordings of bird calls for a climate study. 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 multiple choice options
numbers (0s and 1s). This represents the difference
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 database
System (DBMS)? 3 multiple choice options
An analyst uses the command "SELECT Name FROM A query
Customers WHERE City = 'London';" to get a list of 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, columns, 3 multiple choice options
and the relationships between them. What is this 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 must Transaction
both reserve your seat and process your payment. If either 3 multiple choice options
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 component Query Processor
of the DBMS parses the query, checks it for correctness, 3 multiple choice options
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 information The Database Catalog
about the tables, columns, and indexes in the database. 3 multiple choice options
Where does it find this metadata?
A sudden power outage corrupts a database. The Recovery
Database Administrator uses the transaction log to undo 3 multiple choice options
incomplete transactions and restore the database to a
consistent state. This process is known as:
What is the defining characteristic of a relational Data is organized into tables that consist of rows and columns
database? 3 multiple choice options
A developer is building an application with rapidly changing NoSQL Database
data requirements and large amounts of unstructured data. 3 multiple choice options
Which type of database would be most suitable?
A company chooses to use PostgreSQL, a database Open Source
whose source code is freely available for anyone to view, 3 multiple choice options
modify, and distribute. This type of software license is
known as:
A startup is looking for a powerful relational database that PostgreSQL
requires no initial licensing fees and allows their 3 multiple choice options
developers to view the source code. Which of the following
systems best fits their need for an open-source license?
An application needs to add a new customer to a Create
Customers table. Which CRUD operation does this 3 multiple choice options
represent?
Which language is the international standard for querying SQL
and manipulating data in relational databases? 3 multiple choice options
When creating a table in SQL, what is the purpose of It defines that the column can hold numbers with a total of 8 digits, with 2 of those
specifying a data type like DECIMAL(8, 2) for a Price digits after the decimal point
column? 3 multiple choice options
The acronym CRUD describes the four fundamental Create, Read, Update, Delete
operations in a database. What do the letters stand for? 3 multiple choice options
What are the three primary phases of the database design Conceptual, Logical, Physical
process, in the correct order? 3 multiple choice options
In a standard Entity-Relationship (ER) diagram, what is the To represent the entities
primary purpose of rectangles? 3 multiple choice options
