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