You have two tables named Cars and Color as defined below. The two tables are related by ColorId. You run the following SQL statement: select: How many rows does the SQL statement return?
Outer joins will return all records of the main table, reguardless if there is a match in the related table. Here the main table is the table with 3 rows in it.
in the row where there is only information for the columns in the left table, the columns from the joined table will all return NULL
so for row 2 you will see Truck, 4-door, NULL NULL NULL
Because cars is mentioned first, it is considered the "left" table. If the question was written in some other way and cars was mentioned after color, then color would be considered the "left" table.
This section is not available anymore. Please use the main Exam Page.98-364 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
VincentMars
Highly Voted 5 years, 3 months agodzoni68
Most Recent 3 years agojulie2020
5 years, 2 months agoCiskixe
4 years, 11 months agowelr348jhnksdf
4 years, 4 months agoquan240594
5 years, 4 months ago