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
 

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!




Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

ABOUT SECTION
» About us
» Contact us
» Feedback
» Privacy policy

STUDENT'S SECTION
» Internship
» Certificates
» Content Writers of the Month

SUBSCRIBE
» Facebook
» LinkedIn
» Subscribe through email

© https://www.includehelp.com some rights reserved.