WGU C170 - Data Management – Applications questions
with verified answers
ABS Ans✓✓✓-Returns the absolute value of a number
Access plan Ans✓✓✓-A set of instructions generated at application compilation
time that is created and managed by a DBMS. It predetermines how an
application's query will access the database at run time. Also called an execution
plan.
ADD_MONTHS Ans✓✓✓-Oracle function that adds a number of months or years
to a date
ADDDATE Ans✓✓✓-MYSQL function that adds a number of days to a date
ALL operator Ans✓✓✓-Allows comparison of a single value with a list of values
returned by the first subquery. Uses a comparison operator other than equals.
ALTER TABLE Ans✓✓✓-The SQL command used to make changes to table
structure. When the command is followed by a keyword (ADD or MODIFY), it adds
a column or changes column characteristics.
AND operator Ans✓✓✓-The SQL logical operator used to link multiple
conditional expressions in a WHERE or HAVING clause. It requires that all
conditional expressions evaluate to true.
,ANY operator Ans✓✓✓-Allows comparison of a single value to a list of values and
selects only the rows for which the value is greater than or less than any value in
the list
Atomic attribute Ans✓✓✓-An attribute that cannot be further subdivided to
produce meaningful components. For example, a person's last name attribute
cannot be meaningfully subdivided.
Atomicity Ans✓✓✓-Not being able to be divided into smaller units. Leads to
more flexible queries.
Automatic query optimization Ans✓✓✓-A method by which a DBMS finds the
most efficient access path for the execution of a query.
AVG Ans✓✓✓-A SQL aggregate function that outputs the mean average for a
specified column or expression.
B-tree index Ans✓✓✓-An ordered data structure organized as an upside-down
tree.
Base table Ans✓✓✓-The table on which a view is based.
Batch update routine Ans✓✓✓-A routine that pools transactions into a single
group to update a master table in a single operation.
BETWEEN operator Ans✓✓✓-In SQL, a special comparison operator used to
check whether a value is within a range of specified values.
, Binary relationship Ans✓✓✓-An ER term for an association (relationship)
between two entities. For example, PROFESSOR teaches CLASS.
Bitmap index Ans✓✓✓-An index that uses a bit array (0s and 1s) to represent the
existence of value or condition.
Boolean algebra Ans✓✓✓-A branch of mathematics that uses the logical
operators OR, AND, and NOT.
Candidate key Ans✓✓✓-A minimal superkey; that is, a key that does not contain
a subset of attributes that is itself a superkey.
Cardinality Ans✓✓✓-Denotes how many instances of one object are related to
instances of another object (maximum).
Cascading order sequence Ans✓✓✓-A nested ordering sequence for a set of
rows, such as a list in which all last names are alphabetically ordered and, within
the last names, all first names are ordered.
CEIL/CEILING/FLOOR Ans✓✓✓-Returns the smallest integer greater than or equal
to a number or returns the largest integer equal to or less than a number,
respectively
Closure Ans✓✓✓-A property of relational operators that permits the use of
relational algebra operators on existing tables (relations) to produce new
relations.
with verified answers
ABS Ans✓✓✓-Returns the absolute value of a number
Access plan Ans✓✓✓-A set of instructions generated at application compilation
time that is created and managed by a DBMS. It predetermines how an
application's query will access the database at run time. Also called an execution
plan.
ADD_MONTHS Ans✓✓✓-Oracle function that adds a number of months or years
to a date
ADDDATE Ans✓✓✓-MYSQL function that adds a number of days to a date
ALL operator Ans✓✓✓-Allows comparison of a single value with a list of values
returned by the first subquery. Uses a comparison operator other than equals.
ALTER TABLE Ans✓✓✓-The SQL command used to make changes to table
structure. When the command is followed by a keyword (ADD or MODIFY), it adds
a column or changes column characteristics.
AND operator Ans✓✓✓-The SQL logical operator used to link multiple
conditional expressions in a WHERE or HAVING clause. It requires that all
conditional expressions evaluate to true.
,ANY operator Ans✓✓✓-Allows comparison of a single value to a list of values and
selects only the rows for which the value is greater than or less than any value in
the list
Atomic attribute Ans✓✓✓-An attribute that cannot be further subdivided to
produce meaningful components. For example, a person's last name attribute
cannot be meaningfully subdivided.
Atomicity Ans✓✓✓-Not being able to be divided into smaller units. Leads to
more flexible queries.
Automatic query optimization Ans✓✓✓-A method by which a DBMS finds the
most efficient access path for the execution of a query.
AVG Ans✓✓✓-A SQL aggregate function that outputs the mean average for a
specified column or expression.
B-tree index Ans✓✓✓-An ordered data structure organized as an upside-down
tree.
Base table Ans✓✓✓-The table on which a view is based.
Batch update routine Ans✓✓✓-A routine that pools transactions into a single
group to update a master table in a single operation.
BETWEEN operator Ans✓✓✓-In SQL, a special comparison operator used to
check whether a value is within a range of specified values.
, Binary relationship Ans✓✓✓-An ER term for an association (relationship)
between two entities. For example, PROFESSOR teaches CLASS.
Bitmap index Ans✓✓✓-An index that uses a bit array (0s and 1s) to represent the
existence of value or condition.
Boolean algebra Ans✓✓✓-A branch of mathematics that uses the logical
operators OR, AND, and NOT.
Candidate key Ans✓✓✓-A minimal superkey; that is, a key that does not contain
a subset of attributes that is itself a superkey.
Cardinality Ans✓✓✓-Denotes how many instances of one object are related to
instances of another object (maximum).
Cascading order sequence Ans✓✓✓-A nested ordering sequence for a set of
rows, such as a list in which all last names are alphabetically ordered and, within
the last names, all first names are ordered.
CEIL/CEILING/FLOOR Ans✓✓✓-Returns the smallest integer greater than or equal
to a number or returns the largest integer equal to or less than a number,
respectively
Closure Ans✓✓✓-A property of relational operators that permits the use of
relational algebra operators on existing tables (relations) to produce new
relations.
