WGU - D426: Objective Assessment Questions with Verified
Answers 100% Pass
Database Application - ANSWER -Software
that helps business users interact with database
systems. Transaction Manager - ANSWER -Ensures
transactions are properly executed. The
transaction manager prevents conflicts between
concurrent transactions. The transaction
Database Administrator - ANSWER - manager also restores the database to a
Responsible for securing the database system consistent state in the event of a transaction or
against unauthorized users. A database system failure.
administrator enforces procedures for user
access and database system availability.
Metadata - ANSWER -Data about the
database, such as column names and the
Authorization - ANSWER -Many database number of rows in each table.
users should have limited access to specific
tables, columns, or rows of a database.
Database systems authorize individual users to
access specific data. Relational Database - ANSWER -Stores
data in tables, columns, and rows, similar to a
spreadsheet.
Rules - ANSWER -Database systems
ensure data is consistent with structural and
business rules. Relational Database - ANSWER -All
_________ ________ systems support the SQL
query language.
Query Processor - ANSWER -Interprets
queries, creates a plan to modify the database or
retrieve data, and returns query results to the Relational Database - ANSWER -Relational
application. Performs query optimization to systems are ideal for databases that require an
ensure the most efficient instructions are accurate record of every transaction, such as
executed on the data. banking, airline reservation systems, and student
records.
Storage Manager - ANSWER -Translates
the query processor instructions into low-level MongoDB (NoSQL) - ANSWER -The newer
file-system commands that modify or retrieve non-relational systems are called NoSQL, for 'not
data. Database sizes range from megabytes to only SQL', and are optimized for big data.
many terabytes, so the storage manager uses
indexes to quickly locate data.
, WGU - D426: Objective Assessment Questions with Verified
Answers 100% Pass
SQL Statements - ANSWER -INSERT ANSWER -This phase implements
inserts rows into a table. database requirements in a specific database
SELECT retrieves data from a table. system. For relational database systems,
UPDATE modifies data in a table. _________ design converts entities,
DELETE deletes rows from a table. relationships, and attributes into tables, keys, and
columns.
CREATE TABLE (Statement) - ANSWER -
A statement that creates a new table by Physical Design - ANSWER -Specifies
specifying the table and column names. Each indexes, table structures, and partitions. This
column is assigned a data type that indicates the phase adds indexes and specifies how tables are
format of column values. Data types can be organized on storage media. Affects query
numeric, textual, or complex. processing speed but never affects the query
result.
Data Type - ANSWER -INT stores integer
values. Data Independence - ANSWER -Allows
DECIMAL stores fractional numeric values. database designers to tune query performance
VARCHAR stores textual values. without changes to application programs.
DATE stores year, month, and day.
Application Programming Interface (API) -
Database Design - ANSWER -Analysis ANSWER -To simplify the use of SQL with
Logical design a general-purpose language, database programs
Physical design typically use an ____________ _____________
_______________.
Analysis Phase, Conceptual Design, Entity-
Relationship Modeling (Database Design) - MySQL Command-Line Client - ANSWER -
ANSWER -This phase specifies database A text interface included in the MySQL Server
requirements without regard to a specific download.
database system. Requirements are represented
as entities, relationships, and attributes. An entity
is a person, place, activity, or thing. A
relationship is a link between entities, and an MySQL - ANSWER -'World' database, a
attribute is a descriptive property of an entity. database that is usually installed with ______.
Logical Design (Database Design) - Error Code - ANSWER -MySQL Server
Answers 100% Pass
Database Application - ANSWER -Software
that helps business users interact with database
systems. Transaction Manager - ANSWER -Ensures
transactions are properly executed. The
transaction manager prevents conflicts between
concurrent transactions. The transaction
Database Administrator - ANSWER - manager also restores the database to a
Responsible for securing the database system consistent state in the event of a transaction or
against unauthorized users. A database system failure.
administrator enforces procedures for user
access and database system availability.
Metadata - ANSWER -Data about the
database, such as column names and the
Authorization - ANSWER -Many database number of rows in each table.
users should have limited access to specific
tables, columns, or rows of a database.
Database systems authorize individual users to
access specific data. Relational Database - ANSWER -Stores
data in tables, columns, and rows, similar to a
spreadsheet.
Rules - ANSWER -Database systems
ensure data is consistent with structural and
business rules. Relational Database - ANSWER -All
_________ ________ systems support the SQL
query language.
Query Processor - ANSWER -Interprets
queries, creates a plan to modify the database or
retrieve data, and returns query results to the Relational Database - ANSWER -Relational
application. Performs query optimization to systems are ideal for databases that require an
ensure the most efficient instructions are accurate record of every transaction, such as
executed on the data. banking, airline reservation systems, and student
records.
Storage Manager - ANSWER -Translates
the query processor instructions into low-level MongoDB (NoSQL) - ANSWER -The newer
file-system commands that modify or retrieve non-relational systems are called NoSQL, for 'not
data. Database sizes range from megabytes to only SQL', and are optimized for big data.
many terabytes, so the storage manager uses
indexes to quickly locate data.
, WGU - D426: Objective Assessment Questions with Verified
Answers 100% Pass
SQL Statements - ANSWER -INSERT ANSWER -This phase implements
inserts rows into a table. database requirements in a specific database
SELECT retrieves data from a table. system. For relational database systems,
UPDATE modifies data in a table. _________ design converts entities,
DELETE deletes rows from a table. relationships, and attributes into tables, keys, and
columns.
CREATE TABLE (Statement) - ANSWER -
A statement that creates a new table by Physical Design - ANSWER -Specifies
specifying the table and column names. Each indexes, table structures, and partitions. This
column is assigned a data type that indicates the phase adds indexes and specifies how tables are
format of column values. Data types can be organized on storage media. Affects query
numeric, textual, or complex. processing speed but never affects the query
result.
Data Type - ANSWER -INT stores integer
values. Data Independence - ANSWER -Allows
DECIMAL stores fractional numeric values. database designers to tune query performance
VARCHAR stores textual values. without changes to application programs.
DATE stores year, month, and day.
Application Programming Interface (API) -
Database Design - ANSWER -Analysis ANSWER -To simplify the use of SQL with
Logical design a general-purpose language, database programs
Physical design typically use an ____________ _____________
_______________.
Analysis Phase, Conceptual Design, Entity-
Relationship Modeling (Database Design) - MySQL Command-Line Client - ANSWER -
ANSWER -This phase specifies database A text interface included in the MySQL Server
requirements without regard to a specific download.
database system. Requirements are represented
as entities, relationships, and attributes. An entity
is a person, place, activity, or thing. A
relationship is a link between entities, and an MySQL - ANSWER -'World' database, a
attribute is a descriptive property of an entity. database that is usually installed with ______.
Logical Design (Database Design) - Error Code - ANSWER -MySQL Server
