Introduction to SQL Questions

• To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
• The HAVING clause does which of the following?
• SQL is:
• The result of a SQL SELECT statement is a(n) ________ .
• The SQL keyword BETWEEN is used:
• When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
• The command to remove rows from a table 'CUSTOMER' is:
• ________ was adopted as a national standard by ANSI in 1992.
• The SQL WHERE clause:
• You can add a row using SQL in a database with which of the following?
• Which one of the following sorts rows in SQL?
• SQL can be used to:
• The SQL statement that queries or reads data from a table is ________ .
• Which of the following is the original purpose of SQL?
• Most companies keep at least two versions of any database they are using.
• The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
• Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
• SQL is a data sublanguage.
• SUM, AVG, MIN, and MAX can only be used with numeric columns.
• The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.