SQL Quiz Chap 3 and 4

A ____ file is a text file with a .sql extension that contains SQL commands.

SQL was developed in the mid-____.

To delete an entire table, use the ____ command and then re-create the table.

The ____ operator specifies a range of values in a condition.

Preceding a condition by the ____ operator reverses the truth of the original condition.

The ____ function calculates a total of the values in a column.

The ____ command defines a table’s structure by listing its columns, data types, and column lengths.

The ____ function determines the number of rows in a table.

You form compound conditions by connecting two or more simple conditions using the ____ operator.

In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.

For any column whose data type is CHAR, values must be enclosed in ____.

You use the ____ clause to list data in a specific order.

n SQL, you use the ____ command to query a database.

The basic form of the SQL SELECT command is ____.

The ____ clause lets you group data on a particular column.

Which of the following commands changes the value in a column?

The ____ data type stores only the actual character string.

To display all the rows and columns in a table, type the word SELECT, followed by a(n) ____, followed by the word FROM and then the name of the table containing the data you want to view.

You indicate the end of a command by typing a ____.

Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.

A ___ has this form: column name, comparison operator, and then either another column name or a value

You form ___ ___ by connecting two or more simple conditions using the AND, OR and NOT operators.

The DISTINCT keyword is used to return only distinct (different) values. What is the syntax of a SELECT statement with this keyword added to it?

When a script file contains more than one command, each command must end with a _____.

(True or False)
Aggregate functions apply to groups of rows.
True False

The ______ operator finds rows that do not contain a null value in the specified column

In SQL, you use the _____ command to query a database.

Which of the following commands changes the value in a column?

To include spaces in computed column names, enclose the computed column name in ____.