logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • What is the difference between JOIN and UNION?


  • Correct Answer
  • SQL JOIN allows access to records of other table based on the given conditions between two tables Ex: If we are provided with the department ID of each employee, then we can use the department ID of the employee table to merge with the department ID of the department table to access department names UNION operation allows addition of 2 similar data sets to create a resulting set that contains all the data from the source data sets Ex: If we are provided with 2 employee tables of the same structure, we can UNION them to create a singular result that will contain all employee from both the table 


  • 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