Introduction to SQL problems
- 1. The wildcard in a WHERE clause is useful when?
Options- A. An exact match is necessary in a SELECT statement.
- B. An exact match is not possible in a SELECT statement.
- C. An exact match is necessary in a CREATE statement.
- D. An exact match is not possible in a CREATE statement. Discuss
Correct Answer: An exact match is not possible in a SELECT statement.
- 2. The SQL -92 wildcards are ____ and ____ .
Options- A. asterisk (*); percent sign (%)
- B. percent sign (%); underscore (_)
- C. underscore(_); question mark (?)
- D. question mark (?); asterisk (*) Discuss
Correct Answer: percent sign (%); underscore (_)
- 3. Which of the following are the five built-in functions provided by SQL?
Options- A. COUNT, SUM, AVG, MAX, MIN
- B. SUM, AVG, MIN, MAX, MULT
- C. SUM, AVG, MULT, DIV, MIN
- D. SUM, AVG, MIN, MAX, NAME Discuss
Correct Answer: COUNT, SUM, AVG, MAX, MIN
- 4. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Options- A. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
- B. SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
- C. SELECT NAME IN CUSTOMER WHERE STATE = 'V';
- D. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); Discuss
Correct Answer: SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
- 5. Which of the following is valid SQL for an Index?
Options- A. CREATE INDEX ID;
- B. CHANGE INDEX ID;
- C. ADD INDEX ID;
- D. REMOVE INDEX ID; Discuss
Correct Answer: CREATE INDEX ID;
- 6. 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
Correct Answer: ORDER BY.
- 7. 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
Correct Answer: Reduced training costs
- 8. 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
Correct Answer: All of the above.
- 9. 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
Correct Answer: SELECT, FROM, WHERE
- 10. The SQL keyword(s) ________ is used with wildcards.
Options- A. LIKE only
- B. IN only
- C. NOT IN only
- D. IN and NOT IN Also asked in: Database Administrator, IT Trainer
Correct Answer: LIKE only
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.