Introduction to SQL problems
- 1. Which one of the following sorts rows in SQL?
Options- A. SORT BY
- B. ALIGN BY
- C. ORDER BY
- D. GROUP BY Discuss
Correct Answer: ORDER BY
- 2. SQL can be used to:
Options- A. create database structures only.
- B. query database data only.
- C. modify database data only.
- D. All of the above can be done by SQL. Discuss
Correct Answer: All of the above can be done by SQL.
- 3. The SQL statement that queries or reads data from a table is ________ .
Options- A. SELECT
- B. READ
- C. QUERY
- D. None of the above is correct. Discuss
Correct Answer: SELECT
- 4. Which of the following is the original purpose of SQL?
Options- A. To specify the syntax and semantics of SQL data definition language
- B. To specify the syntax and semantics of SQL manipulation language
- C. To define the data structures
- D. All of the above. Also asked in: Analyst, Database Administrator, IT Trainer
Correct Answer: All of the above.
- 5. Most companies keep at least two versions of any database they are using.
Options- A. True
- B. False Discuss
Correct Answer: True
- 6. The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
Options- A. True
- B. False Discuss
Correct Answer: True
- 7. Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
Options- A. True
- B. False Discuss
Correct Answer: False
- 8. SQL is a data sublanguage.
Options- A. True
- B. False Discuss
Correct Answer: True
- 9. SUM, AVG, MIN, and MAX can only be used with numeric columns.
Options- A. True
- B. False Discuss
Correct Answer: False
- 10. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Options- A. True
- B. False Discuss
Correct Answer: True
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.