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. The benefits of a standard relational language include which of the following?

    • Options
    • A. Reduced training costs
    • B. Increased dependence on a single vendor
    • C. Applications are not needed.
    • D. All of the above.
      • Discuss
    • 2. In ODL, you specify an operation using parentheses after its name.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The JVM (Java virtual machine) interprets Java bytecode at run time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. A rule of thumb for choosing indexes for a relational database includes which of the following?

    • Options
    • A. Indexes are more useful on smaller tables.
    • B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
    • C. Do not specify a unique index for the primary key of each table.
    • D. Be careful indexing attributes that have null values.
      • Discuss
    • 5. Changing cardinalities in a database is:

    • Options
    • A. a common database design task.
    • B. a rare database design task, but does occur.
    • C. a database design task that never occurs.
    • D. is impossible to do, so a new database must be constructed and the data moved into it.
      • Discuss
    • 6. ________ is an object-oriented interface that encapsulates data-server functionality.

    • Options
    • A. ODBC
    • B. OLE DB
    • C. JPCD
    • D. ADO
      • Discuss
    • 7. The following are components of a database except ________ .

    • Options
    • A. user data
    • B. metadata
    • C. reports
    • D. indexes
      • Discuss
    • 8. Which of the following is a technique for hiding the internal implementation details of an object?

    • Options
    • A. Encapsulation
    • B. Polymorphism
    • C. Inheritance
    • D. All of the above.
      • Discuss
    • 9. The three-schema components include all, but:

    • Options
    • A. internal schema.
    • B. conceptual schema.
    • C. programming schema.
    • D. external schema.
      • Discuss
    • 10. Routers are used to transmit message packets and forward them to the correct destination over the most efficient pathway available.

    • 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.