logo

CuriousTab

CuriousTab

Discussion


Home Database Advanced SQL Comments

  • Question
  • Subqueries can be nested multiple times.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Advanced SQL problems


    Search Results


    • 1. The UNION clause is used to combine the output from multiple queries together into a single result table.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. ROLLBACK WORK asks SQL to empty the log file.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. Triggers are stored blocks of code that have to be called in order to operate.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. Both ASP and ColdFusion allow for the coding of custom tags within an HTML document.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. 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
    • 9. 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
    • 10. Most plug-ins download slowly because they are rather large files.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment