Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
Options- A. True
- B. False
- Correct Answer
- False
- 1. SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
Options- A. True
- B. False Discuss
- 2. DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
Options- A. True
- B. False Discuss
- 3. 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
- 4. Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Options- A. True
- B. False Discuss
- 5. Indexes can usually be created for both primary and secondary keys.
Options- A. True
- B. False Discuss
- 6. The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
Options- A. True
- B. False Discuss
- 7. There is an equivalent join expression that can be substituted for all subquery expressions.
Options- A. True
- B. False Discuss
- 8. The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
Options- A. True
- B. False Discuss
- 9. The result of every SQL query is a table.
Options- A. True
- B. False Discuss
- 10. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
Options- A. True
- B. False Discuss
Introduction to SQL problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.