gs gs115 SQL Joins - SQL Left Join - Quiz No.1
gs gs115 Structured Query Language Quiz
This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 4 multiple choice questions (MCQs) to prepare and belongs to topic SQL Joins. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Table1 LEFT JOIN Table2 returns _____
All records from the Table2 and the matched records from the Table1
All records from the Table1 and the matched records from the Table2
Records that have matching values in both tables.
All records when there is a match in either Table1 or Table2
Question 2: If there is no matching row on right side table of LEFT JOIN, the result-set contains ____
Zero
Blank
A default value
Null
Question 3: Instead of LEFT JOIN, which of the following can be used to produce same result?
Join
Left outer join
Left inner join
Inner join
Question 4: Which of the following sets represents table1 LEFT JOIN table2?
Table1
Table1 ∩ Table2
Table1 U Table2
Table2
