1|Page
WGU - D426: Objective Assessment|
Comprehensive Questions With Answers
Database Model-correct-answer-Data structures that prescribe how data is
organized.
Operations that manipulate data structures.
Rules that govern valid data.
Tuple-correct-answer-An ORDERED collection of elements enclosed in
parentheses.
Table-correct-answer-A _____ has a name, a fixed tuple of columns, and a varying
set of rows.
Column-correct-answer-A ______ has a name and a data type.
Row-correct-answer-Is an unnamed tuple of values. Each value corresponds to a
column and belongs to the column's data type.
,2|Page
Data Type-correct-answer-A ____ _____ is a named set of values, from which
column values are drawn.
Union-correct-answer-Selects all rows of two tables.
Aggregate-correct-answer-Computes functions over multiple table rows, such as
sum and count.
Relational Rules-correct-answer-Rules that are logical constraints and ensure data
is valid.
The standard language for Relational Databases...-correct-answer-SQL is the
standard language for relational databases, and is commonly supported in non-
relational databases.
Literals (SQL Syntax)-correct-answer-Explicit values that are string, numeric, or
binary.Strings must be surrounded by single quotes or double quotes.Binary
values are represented with x'0' where the 0 is any hex value.
, 3|Page
Keywords (SQL Syntax)-correct-answer-Words with special meaning.
ex. SELECT, FROM, WHERE
Identifiers (SQL Syntax)-correct-answer-Objects from the database like tables,
columns, etc.
ex. City, Name, Population
SQL Sublanguages-correct-answer-Data Definition Language (DDL) defines the
structure of the database.
Data Query Language (DQL) retrieves data from the database.
Data Manipulation Language (DML) manipulates data stored in a database.
Data Control Language (DCL) controls database user access.
Data Transaction Language (DTL) manages database transactions.
Cell-correct-answer-A single column of a single row.
Not Ordered-correct-answer-Rows
WGU - D426: Objective Assessment|
Comprehensive Questions With Answers
Database Model-correct-answer-Data structures that prescribe how data is
organized.
Operations that manipulate data structures.
Rules that govern valid data.
Tuple-correct-answer-An ORDERED collection of elements enclosed in
parentheses.
Table-correct-answer-A _____ has a name, a fixed tuple of columns, and a varying
set of rows.
Column-correct-answer-A ______ has a name and a data type.
Row-correct-answer-Is an unnamed tuple of values. Each value corresponds to a
column and belongs to the column's data type.
,2|Page
Data Type-correct-answer-A ____ _____ is a named set of values, from which
column values are drawn.
Union-correct-answer-Selects all rows of two tables.
Aggregate-correct-answer-Computes functions over multiple table rows, such as
sum and count.
Relational Rules-correct-answer-Rules that are logical constraints and ensure data
is valid.
The standard language for Relational Databases...-correct-answer-SQL is the
standard language for relational databases, and is commonly supported in non-
relational databases.
Literals (SQL Syntax)-correct-answer-Explicit values that are string, numeric, or
binary.Strings must be surrounded by single quotes or double quotes.Binary
values are represented with x'0' where the 0 is any hex value.
, 3|Page
Keywords (SQL Syntax)-correct-answer-Words with special meaning.
ex. SELECT, FROM, WHERE
Identifiers (SQL Syntax)-correct-answer-Objects from the database like tables,
columns, etc.
ex. City, Name, Population
SQL Sublanguages-correct-answer-Data Definition Language (DDL) defines the
structure of the database.
Data Query Language (DQL) retrieves data from the database.
Data Manipulation Language (DML) manipulates data stored in a database.
Data Control Language (DCL) controls database user access.
Data Transaction Language (DTL) manages database transactions.
Cell-correct-answer-A single column of a single row.
Not Ordered-correct-answer-Rows
