D426 Study Guide (Red Text ONLY) D426 Study Guide (Red Text ONLY) 2/18/2026
Database Application
A _______________ is software that helps business users interact with database systems
Database Administrator
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
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
Database special requirements:
Database systems ensure data is consistent with structural and business______________.
Page 1 D426 Study Guide (Red Text ONLY).pdf
,D426 Study Guide (Red Text ONLY) D426 Study Guide (Red Text ONLY) 2/18/2026
Query Processor
Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and returns query results to the
application.
Query Optimization
Architecture Question:
The query processor performs ___________ to ensure the most efficient instructions are executed on the data.
Storage Manager
Architecture Question:
This translates the query processor instructions into low level file system commands that modify or retrieve data.
1 multiple choice option
Indexes
Database sizes range from megabytes to many terabytes, so the storage manager uses __________ to quickly locate
data.
Page 2 D426 Study Guide (Red Text ONLY).pdf
,D426 Study Guide (Red Text ONLY) D426 Study Guide (Red Text ONLY) 2/18/2026
Transaction Manager
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.
2 multiple choice options
Metadata
General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
2 multiple choice options
Open-Source
Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
3 multiple choice options
Page 3 D426 Study Guide (Red Text ONLY).pdf
, D426 Study Guide (Red Text ONLY) D426 Study Guide (Red Text ONLY) 2/18/2026
NoSQL
What is the MongoDB database Engine type?
3 multiple choice options
INSERT
SQL statement:
This command inputs rows into a table.
3 multiple choice options
SELECT
SQL Statement:
This command retrieves data from a table
3 multiple choice options
Page 4 D426 Study Guide (Red Text ONLY).pdf
Database Application
A _______________ is software that helps business users interact with database systems
Database Administrator
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
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
Database special requirements:
Database systems ensure data is consistent with structural and business______________.
Page 1 D426 Study Guide (Red Text ONLY).pdf
,D426 Study Guide (Red Text ONLY) D426 Study Guide (Red Text ONLY) 2/18/2026
Query Processor
Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and returns query results to the
application.
Query Optimization
Architecture Question:
The query processor performs ___________ to ensure the most efficient instructions are executed on the data.
Storage Manager
Architecture Question:
This translates the query processor instructions into low level file system commands that modify or retrieve data.
1 multiple choice option
Indexes
Database sizes range from megabytes to many terabytes, so the storage manager uses __________ to quickly locate
data.
Page 2 D426 Study Guide (Red Text ONLY).pdf
,D426 Study Guide (Red Text ONLY) D426 Study Guide (Red Text ONLY) 2/18/2026
Transaction Manager
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.
2 multiple choice options
Metadata
General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
2 multiple choice options
Open-Source
Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
3 multiple choice options
Page 3 D426 Study Guide (Red Text ONLY).pdf
, D426 Study Guide (Red Text ONLY) D426 Study Guide (Red Text ONLY) 2/18/2026
NoSQL
What is the MongoDB database Engine type?
3 multiple choice options
INSERT
SQL statement:
This command inputs rows into a table.
3 multiple choice options
SELECT
SQL Statement:
This command retrieves data from a table
3 multiple choice options
Page 4 D426 Study Guide (Red Text ONLY).pdf
