Database - Introduction to SQL
Database - Introduction to SQL
11. The SQL keyword(s) ________ is used with wildcards.
- LIKE only
- IN only
- NOT IN only
- IN and NOT IN
12. Which of the following is the correct order of keywords for SQL SELECT statements?
- SELECT, FROM, WHERE
- FROM, WHERE, SELECT
- WHERE, FROM,SELECT
- SELECT,WHERE,FROM
13. A subquery in an SQL SELECT statement is enclosed in:
- braces -- {...}.
- CAPITAL LETTERS.
- parenthesis -- (...) .
- brackets -- [...].
15. Which of the following are the five built-in functions provided by SQL?
- COUNT, SUM, AVG, MAX, MIN
- SUM, AVG, MIN, MAX, MULT
- SUM, AVG, MULT, DIV, MIN
- SUM, AVG, MIN, MAX, NAME
16. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
- all columns of the table are to be returned.
- all records meeting the full criteria are to be returned.
- all records with even partial criteria met are to be returned.
- None of the above is correct.
17. The HAVING clause does which of the following?
- Acts like a WHERE clause but is used for groups rather than rows.
- Acts like a WHERE clause but is used for rows rather than columns.
- Acts like a WHERE clause but is used for columns rather than groups.
- Acts EXACTLY like a WHERE clause.
18. The SQL -92 wildcards are ____ and ____ .
- asterisk (*); percent sign (%)
- percent sign (%); underscore (_)
- underscore(_); question mark (?)
- question mark (?); asterisk (*)
19. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
- ONLY
- UNIQUE
- DISTINCT
- SINGLE
20. The benefits of a standard relational language include which of the following?
- Reduced training costs
- Increased dependence on a single vendor
- Applications are not needed.
- All of the above.