Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Options- A. ONLY
- B. UNIQUE
- C. DISTINCT
- D. SINGLE
- Correct Answer
- DISTINCT
- 1. The SQL keyword(s) ________ is used with wildcards.
Options- A. LIKE only
- B. IN only
- C. NOT IN only
- D. IN and NOT IN Discuss
- 2. Which of the following is the correct order of keywords for SQL SELECT statements?
Options- A. SELECT, FROM, WHERE
- B. FROM, WHERE, SELECT
- C. WHERE, FROM,SELECT
- D. SELECT,WHERE,FROM Discuss
- 3. Which of the following do you need to consider when you make a table in SQL?
Options- A. Data types
- B. Primary keys
- C. Default values
- D. All of the above. Discuss
- 4. The benefits of a standard relational language include which of the following?
Options- A. Reduced training costs
- B. Increased dependence on a single vendor
- C. Applications are not needed.
- D. All of the above. Discuss
- 5. To sort the results of a query use:
Options- A. SORT BY.
- B. GROUP BY.
- C. ORDER BY.
- D. None of the above is correct. Discuss
- 6. The HAVING clause does which of the following?
Options- 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. Discuss
- 7. SQL is:
Options- A. a programming language.
- B. an operating system.
- C. a data sublanguage.
- D. a DBMS. Discuss
- 8. The result of a SQL SELECT statement is a(n) ________ .
Options- A. report
- B. form
- C. file
- D. table Discuss
- 9. The SQL keyword BETWEEN is used:
Options- A. for ranges.
- B. to limit the columns displayed.
- C. as a wildcard.
- D. None of the above is correct. Discuss
- 10. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Options- A. LIKE only.
- B. IN only.
- C. NOT IN only.
- D. Both IN and NOT IN. Discuss
Introduction to SQL problems
Search Results
Correct Answer: LIKE only
Correct Answer: SELECT, FROM, WHERE
Correct Answer: All of the above.
Correct Answer: Reduced training costs
Correct Answer: ORDER BY.
Correct Answer: Acts like a WHERE clause but is used for groups rather than rows.
Correct Answer: a data sublanguage.
Correct Answer: table
Correct Answer: for ranges.
Correct Answer: Both IN and NOT IN.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.