Introduction to SQL problems
- 1. 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 Discuss
Correct Answer: DISTINCT
- 2. 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
Correct Answer: Acts like a WHERE clause but is used for groups rather than rows.
- 3. SQL is:
Options- A. a programming language.
- B. an operating system.
- C. a data sublanguage.
- D. a DBMS. Discuss
Correct Answer: a data sublanguage.
- 4. The result of a SQL SELECT statement is a(n) ________ .
Options- A. report
- B. form
- C. file
- D. table Discuss
Correct Answer: table
- 5. 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
Correct Answer: for ranges.
- 6. 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
Correct Answer: Both IN and NOT IN.
- 7. The command to remove rows from a table 'CUSTOMER' is:
Options- A. REMOVE FROM CUSTOMER ...
- B. DROP FROM CUSTOMER ...
- C. DELETE FROM CUSTOMER WHERE ...
- D. UPDATE FROM CUSTOMER ... Discuss
Correct Answer: DELETE FROM CUSTOMER WHERE ...
- 8. ________ was adopted as a national standard by ANSI in 1992.
Options- A. Oracle
- B. SQL
- C. Microsoft Access
- D. DBase Discuss
Correct Answer: SQL
- 9. The SQL WHERE clause:
Options- A. limits the column data that are returned.
- B. limits the row data are returned.
- C. Both A and B are correct.
- D. Neither A nor B are correct. Discuss
Correct Answer: limits the row data are returned.
- 10. You can add a row using SQL in a database with which of the following?
Options- A. ADD
- B. CREATE
- C. INSERT
- D. MAKE Discuss
Correct Answer: INSERT
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.