Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
ORDER BY can be combined with the SELECT statements.
Options- A. True
- B. False
- Correct Answer
- True
- 1. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Options- A. True
- B. False Discuss
- 2. 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
- 3. The result of every SQL query is a table.
Options- A. True
- B. False Discuss
- 4. 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
- 5. There is an equivalent join expression that can be substituted for all subquery expressions.
Options- A. True
- B. False Discuss
- 6. Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
Options- A. True
- B. False Discuss
- 7. To establish a range of values, < and > can be used.
Options- A. True
- B. False Discuss
- 8. 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
- 9. The condition in a WHERE clause can refer to only one value.
Options- A. True
- B. False Discuss
- 10. 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
Introduction to SQL problems
Search Results
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
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.