Attributes that limit the type of data that a column can store are called ________________.

normalizers

arguments

parameters

constraints

Which of the following is NOT a SQL privilege for working with data?

INSERT

UPDATE

SELECT

ALTER

When you're using MySQL, the ________________ statement identifies the database that you want to work with.

Which MySQL data type is typically used for variable-length strings?

CHAR

WORDS

VARCHAR

INT

Which SQL statement can be used to change a user's password?

MODIFY

GRANT

USER

RENAME

Write an aggregate expression to find the oldest date in the invoiceDate column: ________________.

Expressions coded in the WHERE clause

can use aggregate search conditions but can't use non-aggregate search conditions

can use non-aggregate search conditions but can't use aggregate search conditions

can use either aggregate search conditions or non-aggregate search conditions

must refer to columns in the SELECT clause

Which of the following is NOT a comparison operator in a SQL statement?

<>

>

!=

=

Which of the following isn't a valid column alias?

total sales

"Total Sales"

total

total_sales

In a SQL statement, the ________________ clause specifies how to sort the rows.

SELECT

ORDER BY

FROM

WHERE