Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Options- A. True
- B. False
- Correct Answer
- True
- 1. SUM, AVG, MIN, and MAX can only be used with numeric columns.
Options- A. True
- B. False Discuss
- 2. SQL is a data sublanguage.
Options- A. True
- B. False Discuss
- 3. Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
Options- A. True
- B. False Discuss
- 4. 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
- 5. Most companies keep at least two versions of any database they are using.
Options- A. True
- B. False Discuss
- 6. The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Options- A. True
- B. False Discuss
- 7. Indexes can usually be created for both primary and secondary keys.
Options- A. True
- B. False Discuss
- 8. Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Options- A. True
- B. False Discuss
- 9. Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
Options- A. True
- B. False Discuss
- 10. DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
Options- A. True
- B. False Discuss
Introduction to SQL problems
Search Results
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.