WGU D426 Study Guide (Red Text ONLY)
Database Application ANS: A _______________ is software that helps business users interact with
database systems
Database Administrator ANS: Database Role:
What role is responsible for securing the database system against unauthorized users. This role enforces
procedures for user access and database system availability.
Authorization ANS: Many database users should have limited access to specific tables, columns, or rows
of a database. What database "special requirement" allows database systems to allow individual users
access to specific data?
Rules ANS: Database special requirements:
Database systems ensure data is consistent with structural and business______________.
Query Processor ANS: Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and returns query results
to the application.
Query Optimization ANS: Architecture Question:
The query processor performs ___________ to ensure the most efficient instructions are executed on
the data.
Storage Manager ANS: Architecture Question:
This translates the query processor instructions into low level file system commands that modify or
retrieve data.
Indexes ANS: Database sizes range from megabytes to many terabytes, so the storage manager uses
__________ to quickly locate data.
,Transaction Manager ANS: Architecture Question:
The ______________ ensures the following:
- Ensures transactions are properly executed.
- Prevents conflicts between concurrent transactions.
- Restores the database to a consistent state in the event of transaction or system failure.
Metadata ANS: General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
Open-Source ANS: Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
NoSQL ANS: What is the MongoDB database Engine type?
INSERT ANS: SQL statement:
This command inputs rows into a table.
SELECT ANS: SQL Statement:
This command retrieves data from a table
UPDATE ANS: SQL Statement:
This command modifies data in a table.
DELETE ANS: SQL Statement:
This command deletes rows from a table.
, CREATE TABLE ANS: SQL Statement:
This statement makes a new table by specifying the table and column names.
Data Type ANS: During creation, each column is assigned a ____________ that indicates the format of
column values. These can be numeric, textual, or complex.
INT ANS: Data Type Question:
This data type stores integer values.
DECIMAL ANS: Data Type Question:
This datatype stores fractional numeric values.
VARCHAR ANS: Data Type Question:
This datatype stores textual values.
DATE ANS: Data Type Question:
This datatype stores year, month, and day.
Analysis ANS: Name for the first phase of database design.
Logical Design ANS: Name for the second phase of database design.
Physical Design ANS: Name for the third phase of database design.
Analysis ANS: Database Design phases:
Database Application ANS: A _______________ is software that helps business users interact with
database systems
Database Administrator ANS: Database Role:
What role is responsible for securing the database system against unauthorized users. This role enforces
procedures for user access and database system availability.
Authorization ANS: Many database users should have limited access to specific tables, columns, or rows
of a database. What database "special requirement" allows database systems to allow individual users
access to specific data?
Rules ANS: Database special requirements:
Database systems ensure data is consistent with structural and business______________.
Query Processor ANS: Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and returns query results
to the application.
Query Optimization ANS: Architecture Question:
The query processor performs ___________ to ensure the most efficient instructions are executed on
the data.
Storage Manager ANS: Architecture Question:
This translates the query processor instructions into low level file system commands that modify or
retrieve data.
Indexes ANS: Database sizes range from megabytes to many terabytes, so the storage manager uses
__________ to quickly locate data.
,Transaction Manager ANS: Architecture Question:
The ______________ ensures the following:
- Ensures transactions are properly executed.
- Prevents conflicts between concurrent transactions.
- Restores the database to a consistent state in the event of transaction or system failure.
Metadata ANS: General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
Open-Source ANS: Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
NoSQL ANS: What is the MongoDB database Engine type?
INSERT ANS: SQL statement:
This command inputs rows into a table.
SELECT ANS: SQL Statement:
This command retrieves data from a table
UPDATE ANS: SQL Statement:
This command modifies data in a table.
DELETE ANS: SQL Statement:
This command deletes rows from a table.
, CREATE TABLE ANS: SQL Statement:
This statement makes a new table by specifying the table and column names.
Data Type ANS: During creation, each column is assigned a ____________ that indicates the format of
column values. These can be numeric, textual, or complex.
INT ANS: Data Type Question:
This data type stores integer values.
DECIMAL ANS: Data Type Question:
This datatype stores fractional numeric values.
VARCHAR ANS: Data Type Question:
This datatype stores textual values.
DATE ANS: Data Type Question:
This datatype stores year, month, and day.
Analysis ANS: Name for the first phase of database design.
Logical Design ANS: Name for the second phase of database design.
Physical Design ANS: Name for the third phase of database design.
Analysis ANS: Database Design phases:
