D426 Study Guide Exam Questions with Verified
Correct Answers
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.
,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.
Metadata
General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
Open-Source
Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
NoSQL
What is the MongoDB database Engine type?
INSERT
SQL statement:
This command inputs rows into a table.
SELECT
SQL Statement:
This command retrieves data from a table
UPDATE
SQL Statement:
This command modifies data in a table.
DELETE
SQL Statement:
This command deletes rows from a table.
CREATE TABLE
, SQL Statement:
This statement makes a new table by specifying the table and column names.
Data Type
During creation, each column is assigned a ____________ that indicates the format of column
values. These can be numeric, textual, or complex.
INT
Data Type Question:
This data type stores integer values.
DECIMAL
Data Type Question:
This datatype stores fractional numeric values.
VARCHAR
Data Type Question:
This datatype stores textual values.
DATE
Data Type Question:
This datatype stores year, month, and day.
Analysis
Name for the first phase of database design.
Logical Design
Name for the second phase of database design.
Physical Design
Name for the third phase of database design.
Analysis
Database Design phases:
This phase specifies database requirements without regard to a specific database system.
Requirements are represented as entities, relationships, and attributes.
Relationship
Correct Answers
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.
,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.
Metadata
General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc.
Open-Source
Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
NoSQL
What is the MongoDB database Engine type?
INSERT
SQL statement:
This command inputs rows into a table.
SELECT
SQL Statement:
This command retrieves data from a table
UPDATE
SQL Statement:
This command modifies data in a table.
DELETE
SQL Statement:
This command deletes rows from a table.
CREATE TABLE
, SQL Statement:
This statement makes a new table by specifying the table and column names.
Data Type
During creation, each column is assigned a ____________ that indicates the format of column
values. These can be numeric, textual, or complex.
INT
Data Type Question:
This data type stores integer values.
DECIMAL
Data Type Question:
This datatype stores fractional numeric values.
VARCHAR
Data Type Question:
This datatype stores textual values.
DATE
Data Type Question:
This datatype stores year, month, and day.
Analysis
Name for the first phase of database design.
Logical Design
Name for the second phase of database design.
Physical Design
Name for the third phase of database design.
Analysis
Database Design phases:
This phase specifies database requirements without regard to a specific database system.
Requirements are represented as entities, relationships, and attributes.
Relationship
