Podcast
Questions and Answers
A ______ statement allows us to access information from two or more tables at once.
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.
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.
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.
The LEFT (OUTER) JOIN returns all records from the ______ table and matched records from the right.
Signup and view all the answers
The RIGHT (OUTER) JOIN returns all records from the ______ table and the matched records from the left.
The RIGHT (OUTER) JOIN returns all records from the ______ table and the matched records from the left.
Signup and view all the answers
The FULL (OUTER) JOIN returns all records when there is a match in either the ______ table or right table.
The FULL (OUTER) JOIN returns all records when there is a match in either the ______ table or right table.
Signup and view all the answers
The ______ JOIN clause allows us to combine rows from two or more tables based on a related column.
The ______ JOIN clause allows us to combine rows from two or more tables based on a related column.
Signup and view all the answers
The INNER JOIN returns ______ that have matching values in both tables.
The INNER JOIN returns ______ that have matching values in both tables.
Signup and view all the answers
The LEFT (OUTER) JOIN returns all records from the left table and ______ records from the right.
The LEFT (OUTER) JOIN returns all records from the left table and ______ records from the right.
Signup and view all the answers
The RIGHT (OUTER) JOIN returns all records from the right table and the ______ records from the left.
The RIGHT (OUTER) JOIN returns all records from the right table and the ______ records from the left.
Signup and view all the answers
