Advance SQL Queries Aptitude Questions and Answers.

This section contains Aptitude Questions and Answers on Advance SQL topics like Join, Group By, Having etc.

List of Advance SQL Queries Aptitude Questions

1) Which SQL Clause is used to combine data from two or more tables?
  1. ADD
  2. INSERT INTO
  3. MERGE
  4. JOIN

2) Which is not a valid type of JOIN?
  1. INNER JOIN
  2. LEFT UPPER JOIN
  3. OUTER JOIN
  4. LEFT OUTER JOIN

3) Which type of JOIN is used to returns all rows, if there is one match in both tables?
  1. INNER JOIN
  2. OUTER JOIN
  3. FULL JOIN
  4. LEFT JOIN

4) Which type of JOIN is used to returns all rows from left table and only matched rows from right table?
  1. INNER JOIN
  2. OUTER JOIN
  3. FULL JOIN
  4. LEFT JOIN

5) Which type of JOIN is used to returns all rows from right table and only matched rows from left table?
  1. INNER JOIN
  2. RIGHT JOIN
  3. FULL JOIN
  4. LEFT JOIN