D426 STUDY GUIDE (RED TEXT ONLY)
EXAM QUESTIONS WITH COMPLETE
SOLUTIONS 2025/2026
,Database Application - ANSWERA _______________ is software that helps business
users interact with database systems
Database Administrator - ANSWERDatabase 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 - ANSWERMany 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 - ANSWERDatabase special requirements:
Database systems ensure data is consistent with structural and
business______________.
Query Processor - ANSWERArchitecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
Query Optimization - ANSWERArchitecture Question:
The query processor performs ___________ to ensure the most efficient instructions
are executed on the data.
Storage Manager - ANSWERArchitecture Question:
This translates the query processor instructions into low level file system commands
that modify or retrieve data.
Indexes - ANSWERDatabase sizes range from megabytes to many terabytes, so the
storage manager uses __________ to quickly locate data.
Transaction Manager - ANSWERArchitecture 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 - ANSWERGeneral Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
Open-Source - ANSWERIs the MongoDB database engine Open-Source, Private, Free,
or Commercial?
, NoSQL - ANSWERWhat is the MongoDB database Engine type?
INSERT - ANSWERSQL statement:
This command inputs rows into a table.
SELECT - ANSWERSQL Statement:
This command retrieves data from a table
UPDATE - ANSWERSQL Statement:
This command modifies data in a table.
DELETE - ANSWERSQL Statement:
This command deletes rows from a table.
CREATE TABLE - ANSWERSQL Statement:
This statement makes a new table by specifying the table and column names.
Data Type - ANSWERDuring creation, each column is assigned a ____________ that
indicates the format of column values. These can be numeric, textual, or complex.
INT - ANSWERData Type Question:
This data type stores integer values.
DECIMAL - ANSWERData Type Question:
This datatype stores fractional numeric values.
VARCHAR - ANSWERData Type Question:
This datatype stores textual values.
DATE - ANSWERData Type Question:
This datatype stores year, month, and day.
Analysis - ANSWERName for the first phase of database design.
Logical Design - ANSWERName for the second phase of database design.
Physical Design - ANSWERName for the third phase of database design.
Analysis - ANSWERDatabase Design phases:
This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes.
Relationship - ANSWERDatabase Design Related Question:
A(n) ____________ is a link between entities.
EXAM QUESTIONS WITH COMPLETE
SOLUTIONS 2025/2026
,Database Application - ANSWERA _______________ is software that helps business
users interact with database systems
Database Administrator - ANSWERDatabase 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 - ANSWERMany 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 - ANSWERDatabase special requirements:
Database systems ensure data is consistent with structural and
business______________.
Query Processor - ANSWERArchitecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
Query Optimization - ANSWERArchitecture Question:
The query processor performs ___________ to ensure the most efficient instructions
are executed on the data.
Storage Manager - ANSWERArchitecture Question:
This translates the query processor instructions into low level file system commands
that modify or retrieve data.
Indexes - ANSWERDatabase sizes range from megabytes to many terabytes, so the
storage manager uses __________ to quickly locate data.
Transaction Manager - ANSWERArchitecture 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 - ANSWERGeneral Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
Open-Source - ANSWERIs the MongoDB database engine Open-Source, Private, Free,
or Commercial?
, NoSQL - ANSWERWhat is the MongoDB database Engine type?
INSERT - ANSWERSQL statement:
This command inputs rows into a table.
SELECT - ANSWERSQL Statement:
This command retrieves data from a table
UPDATE - ANSWERSQL Statement:
This command modifies data in a table.
DELETE - ANSWERSQL Statement:
This command deletes rows from a table.
CREATE TABLE - ANSWERSQL Statement:
This statement makes a new table by specifying the table and column names.
Data Type - ANSWERDuring creation, each column is assigned a ____________ that
indicates the format of column values. These can be numeric, textual, or complex.
INT - ANSWERData Type Question:
This data type stores integer values.
DECIMAL - ANSWERData Type Question:
This datatype stores fractional numeric values.
VARCHAR - ANSWERData Type Question:
This datatype stores textual values.
DATE - ANSWERData Type Question:
This datatype stores year, month, and day.
Analysis - ANSWERName for the first phase of database design.
Logical Design - ANSWERName for the second phase of database design.
Physical Design - ANSWERName for the third phase of database design.
Analysis - ANSWERDatabase Design phases:
This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes.
Relationship - ANSWERDatabase Design Related Question:
A(n) ____________ is a link between entities.
