Exam 8: Using SQL

SQL is a non-standardized language.

Less than ( ), and NOT (not equal to) are examples of _____.

When you create SQL queries, you should follow some general guidelines for query design. What are these six guidelines?

To assign a name to the results of a function, follow the expression for the function with the word ____________________ and then the name to be assigned to the result.

To include all fields in a SQL query, use the _____ symbol after the word SELECT.

SQL was developed under the name _____ at the IBM San Jose research facilities.

Modified Multiple Choice If data is to be sorted on two fields, the more important key is called the _____.

If you want to list all the rows in the tables, you do not need to include the word WHERE in a SQL statement.

There are two different versions for the "not equal to" comparison operator; and _____.

You can use a(n) _____ clause with a list as an alternative to an OR criterion when the OR criterion involves a single field.

The ____________________ wildcard represents any collection of characters.

To save a query, click the Save button on the ____.

To assign a name to a calculation, follow the calculation with the word AS and then the name to be assigned to the result.

The _____ query enables you to send SQL commands directly to ODBC (Open Database Connectivity) databases.

To create a SQL query that does not involve an exact match, use the ____________________ operator.

If you need to search for a value that contains only a certain collection of characters, use the _____ operator with a wildcard symbol.

When a name containing a space appears in SQL, it must be enclosed in square brackets .

The at symbol (@) wildcard represents any collections of characters.

The _____ query allows you to create or alter database tables or create indexes in Access directly.