Discussion
Home ‣ Database ‣ Advanced SQL Comments
- Question
The UNION clause is used to combine the output from multiple queries together into a single result table.
Options- A. True
- B. False
- Correct Answer
- True
- 1. ROLLBACK WORK asks SQL to empty the log file.
Options- A. True
- B. False Discuss
- 2. Triggers are stored blocks of code that have to be called in order to operate.
Options- A. True
- B. False Discuss
- 3. The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
Options- A. True
- B. False Discuss
- 4. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
Options- A. True
- B. False Discuss
- 5. When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
Options- A. True
- B. False Discuss
- 6. Subqueries can be nested multiple times.
Options- A. True
- B. False Discuss
- 7. Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
Options- A. True
- B. False Discuss
- 8. Both ASP and ColdFusion allow for the coding of custom tags within an HTML document.
Options- A. True
- B. False Discuss
- 9. A load-balancing approach where requests to one IP address are distributed among the multiple servers hosting the Website at the TCP/IP routing level is DNS (domain name server) balancing.
Options- A. True
- B. False Discuss
- 10. Virus detection is a problem with encrypted messages, because the virus may not be detectable until the message is unencrypted.
Options- A. True
- B. False Discuss
Advanced SQL problems
Search Results
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.