WGU C170 CHAPTER 3 QUESTRIONS AND ANSWERS LATEST UPDATED
10 views 0 purchase
Module
WGU C170
Institution
WGU C170
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 cha...
wgu c170 chapter 3 questrions and answers latest u
Written for
WGU C170
All documents for this subject (500)
Seller
Follow
SUPERGRADES01
Reviews received
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller SUPERGRADES01. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £6.03. You're not tied to anything after your purchase.
