Microsoft Certified Azure Data Fundamentals · Free Practice Question Easy
Question 10
When trying to merge rows from two tables based on a related column, which of the following SQL keywords can we use?
-
A
ATTACH
-
B
UNION
-
C
MERGE
-
D
JOIN
Reveal correct answer
Correct answer: D
Explanation
In the context of databases, a "join" is an operation that combines rows from two or more tables based on a related column between them. It is used to retrieve data from multiple tables simultaneously, allowing you to create meaningful and comprehensive results by linking related information.
Reference: https://www.w3schools.com/sql/sql_join.asp
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
