Database - Introduction to SQL
Exercise :: Introduction to SQL - General Questions
| 16. |
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: |
| A. |
all columns of the table are to be returned. | | B. |
all records meeting the full criteria are to be returned. | | C. |
all records with even partial criteria met are to be returned. | | D. |
None of the above is correct. |
Answer: Option A
Explanation:
|
| 17. |
The HAVING clause does which of the following? |
| A. |
Acts like a WHERE clause but is used for groups rather than rows. | | B. |
Acts like a WHERE clause but is used for rows rather than columns. | | C. |
Acts like a WHERE clause but is used for columns rather than groups. | | D. |
Acts EXACTLY like a WHERE clause. |
Answer: Option A
Explanation:
|
| 18. |
The SQL -92 wildcards are ____ and ____ . |
| A. |
asterisk (*); percent sign (%) | | B. |
percent sign (%); underscore (_) | | C. |
underscore(_); question mark (?) | | D. |
question mark (?); asterisk (*) |
Answer: Option B
Explanation:
|
| 19. |
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. |
Answer: Option C
Explanation:
|
| 20. |
The benefits of a standard relational language include which of the following? |
| A. |
Reduced training costs | | B. |
Increased dependence on a single vendor | | C. |
Applications are not needed. | | D. |
All of the above. |
Answer: Option A
Explanation:
|
