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

Q. What SQL command can be used to delete columns from a table?

View solution

Q. Which SQL-92 standard SQL command can be used to change a table name?

View solution

Q. How can you find rows that do not match some specified condition?

View solution