Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
Options- A. True
- B. False
- Correct Answer
- True
- 1. COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
Options- A. True
- B. False Discuss
- 2. The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
Options- A. True
- B. False Discuss
- 3. If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
Options- A. True
- B. False Discuss
- 4. The condition in a WHERE clause can refer to only one value.
Options- A. True
- B. False Discuss
- 5. SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
Options- A. True
- B. False Discuss
- 6. The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Options- A. True
- B. False Discuss
- 7. A dynamic view is one whose contents materialize when referenced.
Options- A. True
- B. False Discuss
- 8. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
Options- A. True
- B. False Discuss
- 9. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
Options- A. True
- B. False Discuss
- 10. Indexes may be created or dropped at any time.
Options- A. True
- B. False Discuss
Introduction to SQL problems
Search Results
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.