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











Was this page helpful? YES NO

Are you a blogger? Join our Blogging forum.



Comments and Discussions


We are using Google to publish ads on our website; Google has its own privacy policies. They may save log, cookies on your system. Google may also collect information of your system like IP address, region, city, country. For more details please go through the Google’s privacy policy.