logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Advanced SQL See What Others Are Saying!
  • Question

  • Which of the following is a correlated subquery?


  • Options
  • A. Uses the result of an inner query to determine the processing of an outer query.
  • B. Uses the result of an outer query to determine the processing of an inner query.
  • C. Uses the result of an inner query to determine the processing of an inner query.
  • D. Uses the result of an outer query to determine the processing of an outer query.

  • Correct Answer
  • Uses the result of an outer query to determine the processing of an inner query. 

    Explanation
    Correlated subquery references a column in the outer query and executes the subquery once for every row in the outer query while Uncorrelated subquery executes the subquery first and passes the value to the outer query.

    • More questions

    • 1. An abstraction is a generalization of something.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. SQL Server AFTER Triggers may be assigned views.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. 'dbo' stands for database object.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. SQL is a data sublanguage.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Which one of the following symbols is not used in an ERD?

    • Options
    • A. Rectangle
    • B. Oval
    • C. Diamond
    • D. Circle
      • Discuss
    • 6. Data in operational systems are typically fragmented and inconsistent.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. VBScript is similar to JavaScript.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The source of the data is sometimes called the system of record.

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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.