Q. A subquery in an SQL SELECT statement is enclosed in:

View solution

Q. The result of a SQL SELECT statement is a(n) ________ .

View solution

Q. Which of the following are the five built-in functions provided by SQL?

View solution

Q. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

View solution

Q. The SQL -92 wildcards are ____ and ____ .

View solution

Q. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

View solution

Q. SQL query and modification commands make up a(n) ________ .

View solution

Q. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

View solution

Q. The Microsoft Access wildcards are ____ and ____ .

View solution

Q. Find the SQL statement below that is equal to the following:
SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

View solution

Q. To sort the results of a query use:

View solution

Q. To define what columns should be displayed in an SQL SELECT statement:

View solution

Q. SQL can be used to:

View solution

Q. The SQL statement that queries or reads data from a table is ________ .

View solution

Q. The SQL keyword BETWEEN is used:

View solution

Q. A subquery in an SQL SELECT statement:

View solution

Q. ________ was adopted as a national standard by ANSI in 1992.

View solution

Q. SQL is:

View solution

Q. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

View solution

Q. Which of the following SQL statements are helpful in database redesign?

View solution