D426 Study Guide (Red
Text ONLY) Exam
(2025-2026)
Question and Answers
Expert Verified
(With A+ Grades Guarantee)
,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______________.
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.
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
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
UPDATE SQL Statement:
This command modifies data in a table.
3 multiple choice options
DELETE SQL Statement:
This command deletes rows from a table.
3 multiple choice options
CREATE TABLE SQL Statement:
This statement makes a new table by specifying the table and column names.
3 multiple choice options
Data Type During creation, each column is assigned a ____________ that indicates the format
of column values. These can be numeric, textual, or complex.
2 multiple choice options
INT Data Type Question:
This data type stores integer values.
3 multiple choice options
DECIMAL Data Type Question:
This datatype stores fractional numeric values.
3 multiple choice options
VARCHAR Data Type Question:
This datatype stores textual values.
3 multiple choice options
DATE Data Type Question:
This datatype stores year, month, and day.
3 multiple choice options
Analysis Name for the first phase of database design.
3 multiple choice options
Logical Design Name for the second phase of database design.
3 multiple choice options
Physical Design Name for the third phase of database design.
3 multiple choice options
Analysis Database Design phases:
This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes.
3 multiple choice options
Relationship Database Design Related Question:
A(n) ____________ is a link between entities.
1 multiple choice option
Text ONLY) Exam
(2025-2026)
Question and Answers
Expert Verified
(With A+ Grades Guarantee)
,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______________.
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.
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
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
UPDATE SQL Statement:
This command modifies data in a table.
3 multiple choice options
DELETE SQL Statement:
This command deletes rows from a table.
3 multiple choice options
CREATE TABLE SQL Statement:
This statement makes a new table by specifying the table and column names.
3 multiple choice options
Data Type During creation, each column is assigned a ____________ that indicates the format
of column values. These can be numeric, textual, or complex.
2 multiple choice options
INT Data Type Question:
This data type stores integer values.
3 multiple choice options
DECIMAL Data Type Question:
This datatype stores fractional numeric values.
3 multiple choice options
VARCHAR Data Type Question:
This datatype stores textual values.
3 multiple choice options
DATE Data Type Question:
This datatype stores year, month, and day.
3 multiple choice options
Analysis Name for the first phase of database design.
3 multiple choice options
Logical Design Name for the second phase of database design.
3 multiple choice options
Physical Design Name for the third phase of database design.
3 multiple choice options
Analysis Database Design phases:
This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes.
3 multiple choice options
Relationship Database Design Related Question:
A(n) ____________ is a link between entities.
1 multiple choice option
