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|Pag
iy iy iy iy
e
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|Pagiy iy iy iy
e
Keywords (SQL Syntax)-correct-answer-Words with special meaning.
iy iy iy iy iy
ex. SELECT, FROM, WHERE
iy iy iy
Identifiers (SQL Syntax)-correct-answer-Objects from the database like tables,
iy iy iy iy iy iy iy
columns, etc.
iy iy
ex. City, Name, Population
iy iy iy
SQL Sublanguages-correct-answer-Data Definition Language (DDL) defines the
iy iy iy iy iy iy
structure of the database.
iy iy iy iy
Data Query Language (DQL) retrieves data from the database.
iy iy iy iy iy iy iy iy
Data Manipulation Language (DML) manipulates data stored in a database.
iy iy iy iy iy iy iy iy iy
iy Data Control Language (DCL) controls database user access.
iy iy iy iy iy iy iy
Data Transaction Language (DTL) manages database transactions.
iy iy iy iy iy iy
Cell-correct-answer-A single column of a single row. iy iy iy iy iy iy
Not Ordered-correct-answer-Rows
iy
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|Pag
iy iy iy iy
e
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|Pagiy iy iy iy
e
Keywords (SQL Syntax)-correct-answer-Words with special meaning.
iy iy iy iy iy
ex. SELECT, FROM, WHERE
iy iy iy
Identifiers (SQL Syntax)-correct-answer-Objects from the database like tables,
iy iy iy iy iy iy iy
columns, etc.
iy iy
ex. City, Name, Population
iy iy iy
SQL Sublanguages-correct-answer-Data Definition Language (DDL) defines the
iy iy iy iy iy iy
structure of the database.
iy iy iy iy
Data Query Language (DQL) retrieves data from the database.
iy iy iy iy iy iy iy iy
Data Manipulation Language (DML) manipulates data stored in a database.
iy iy iy iy iy iy iy iy iy
iy Data Control Language (DCL) controls database user access.
iy iy iy iy iy iy iy
Data Transaction Language (DTL) manages database transactions.
iy iy iy iy iy iy
Cell-correct-answer-A single column of a single row. iy iy iy iy iy iy
Not Ordered-correct-answer-Rows
iy
