10 Questions
A ______ statement allows us to access information from two or more tables at once.
join
Normalization allows us to keep ______ low so that we can decrease the amount of data anomalies in our application when we delete or update a record.
data redundancy
The ______ JOIN keyword selects all rows from both the tables as long as the condition satisfies.
INNER
The LEFT (OUTER) JOIN returns all records from the ______ table and matched records from the right.
left
The RIGHT (OUTER) JOIN returns all records from the ______ table and the matched records from the left.
right
The FULL (OUTER) JOIN returns all records when there is a match in either the ______ table or right table.
left
The ______ JOIN clause allows us to combine rows from two or more tables based on a related column.
join
The INNER JOIN returns ______ that have matching values in both tables.
dataset
The LEFT (OUTER) JOIN returns all records from the left table and ______ records from the right.
matched
The RIGHT (OUTER) JOIN returns all records from the right table and the ______ records from the left.
matched
Learn about the INNER JOIN syntax in SQL Server, which combines rows from two tables based on a matching condition. This quiz provides an example of how to use INNER JOIN to retrieve data from multiple tables.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free