WGU C170 CHAPTER 3 QUESTRIONS AND ANSWERS
LATEST UPDATED
alias
An alternative name for a column or table in a SQL statement.
ALTER TABLE
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
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.
authentication
The process through which a DBMS verifies that only registered users can access the
database.
AVG
A SQL aggregate function that outputs the mean average for a specified column or
expression.
BETWEEN
In SQL, a special comparison operator used to check whether a value is within a range
of specified values.
Boolean algebra
A branch of mathematics that uses the logical operators OR, AND, and NOT.
cascading order sequence
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.
COMMIT
The SQL command that permanently writes data changes to a database.
COUNT
, A SQL aggregate function that outputs the number of rows containing not null values for
a given column or expression, sometimes used in conjunction with the DISTINCT
clause.
CREATE INDEX
A SQL command that creates indexes on the basis of a selected attribute or attributes.
CREATE TABLE
A SQL command that creates a table's structures using the characteristics and
attributes given.
DELETE
A SQL command that allows data rows to be deleted from a table.
DISTINCT
A SQL clause that produces only a list of values that are different from one another.
DROP INDEX
A SQL command used to delete database objects such as tables, views, indexes, and
users.
DROP TABLE
A SQL command used to delete database objects such as tables, views, indexes, and
users.
EXISTS
In SQL, a comparison operator that checks whether a subquery returns any rows.
FROM
A SQL clause that specifies the table or tables from which data is to be retrieved.
GROUP BY
A SQL clause used to create frequency distributions when combined with any of the
aggregate functions in a SELECT statement.
HAVING
A clause applied to the output of a GROUP BY operation to restrict selected rows.
IN
In SQL, a comparison operator used to check whether a value is among a list of
specified values.
inner query
LATEST UPDATED
alias
An alternative name for a column or table in a SQL statement.
ALTER TABLE
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
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.
authentication
The process through which a DBMS verifies that only registered users can access the
database.
AVG
A SQL aggregate function that outputs the mean average for a specified column or
expression.
BETWEEN
In SQL, a special comparison operator used to check whether a value is within a range
of specified values.
Boolean algebra
A branch of mathematics that uses the logical operators OR, AND, and NOT.
cascading order sequence
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.
COMMIT
The SQL command that permanently writes data changes to a database.
COUNT
, A SQL aggregate function that outputs the number of rows containing not null values for
a given column or expression, sometimes used in conjunction with the DISTINCT
clause.
CREATE INDEX
A SQL command that creates indexes on the basis of a selected attribute or attributes.
CREATE TABLE
A SQL command that creates a table's structures using the characteristics and
attributes given.
DELETE
A SQL command that allows data rows to be deleted from a table.
DISTINCT
A SQL clause that produces only a list of values that are different from one another.
DROP INDEX
A SQL command used to delete database objects such as tables, views, indexes, and
users.
DROP TABLE
A SQL command used to delete database objects such as tables, views, indexes, and
users.
EXISTS
In SQL, a comparison operator that checks whether a subquery returns any rows.
FROM
A SQL clause that specifies the table or tables from which data is to be retrieved.
GROUP BY
A SQL clause used to create frequency distributions when combined with any of the
aggregate functions in a SELECT statement.
HAVING
A clause applied to the output of a GROUP BY operation to restrict selected rows.
IN
In SQL, a comparison operator used to check whether a value is among a list of
specified values.
inner query
