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