logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • What is correlated query? Explain its uses.


  • Correct Answer
  • In a correlated query, the outer query is related to the inner query This means one or more columns in the outer query are referenced It?s used when the outer queries value is being used by inner query For example, we need to find which employee had more perks in the current month than they did in the previous month The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned 


  • More questions

    • 1. How would you automatically transfer your visitors to a new web page?
    • Discuss
    • 2. The threshold limit upto which coins can be issued as per the Coinage Act 2011 ?

    • Options
    • A. 100
    • B. 200
    • C. 500
    • D. 1000
    • Discuss
    • 3. Cash Reserve Ratio ( CRR) and Stautory Liquidity Ratio (SLR ) are terms most closely related to which of the following industries/markets :

    • Options
    • A. Mutual Fund
    • B. Income Tax
    • C. Stock Exchange
    • D. Banking
    • Discuss
    • 4. What is the minimum period of time for which one can open an FD(Fixed Deposit) account ?

    • Options
    • A. 15 days
    • B. 6 months
    • C. 7 days
    • D. 1 year
    • Discuss
    • 5. Which Bank has been given scheduled bank status by RBI ?

    • Options
    • A. Disha
    • B. Suryoday
    • C. Janalakshmi
    • D. Ujjivan
    • Discuss
    • 6. Which class is used to indicate Black Navigation Bar ?

    • Options
    • A. .navbar-inverse
    • B. .navbar-black
    • C. .navbar-dark
    • D. .navbar-default
    • Discuss
    • 7. The journal entry to record a credit sale is

    • Options
    • A. Accounts Receivable
    • B. Accounts Payable
    • C. Both A & B
    • D. None of the above
    • Discuss
    • 8. What is CRR rate?
    • Discuss
    • 9. Which among the following are not access Specifiers in C++?

    • Options
    • A. Public
    • B. Protected
    • C. Default
    • D. Private
    • Discuss
    • 10. In which year, the first bank of India "Bank of Hindustan" was established ?

    • Options
    • A. 1677
    • B. 1770
    • C. 1796
    • D. 1831
    • Discuss


    Comments

    There are no comments.

Enter a new Comment