IncludeHelp_logo
Skip Navigation Links

Home » Aptitude Questions & Answers » DBMS Aptitude Questions

Advance SQL Queries Aptitude Questions and Answers | Set 2

List of Advance SQL Queries Aptitude Questions

6) Which type of JOIN is used to returns all rows, if there a match in one of the tables?
  1. INNER JOIN
  2. LEFT JOIN
  3. RIGHT JOIN
  4. FULL JOIN
Answer

7) The SQL UNION Operator is combines the result of two or more ________ statements.
  1. INSERT
  2. UPDATE
  3. SELECT
  4. DELETE
Answer

8) Is UNION and UNION ALL same?
  1. YES
  2. NO
Answer

9) What is the difference between UNION and UNION ALL?
  1. UNION Operator returns all values while UNION ALL returns only DISTINCT values.
  2. UNION Operator returns only DISTINCT values while UNION ALL returns all values.
  3. UNION Operator returns only first records from second query while UNION ALL returns all records from second query.
  4. None of these.
Answer

10) Which is the correct syntax for UNION Operator?
  1. SELECT column_name(s) FROM TABLE table_name1
     UNION
     SELECT column_name(s) FROM TABLE table_name2
  2. SELECT column_name(s) FROM table_name1
     UNION table_name2
  3. SELECT column_name(s) FROM table_name1
     UNION
     SELECT column_name(s) FROM table_name2
  4. SELECT column_name(s) FROM table_name1 UNION table_name2
Answer

Advance SQL Queries Aptitude Questions | Set 1
 



Comments and Discussions!

Load comments ↻



Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.