There is a requirement to combine data from two different tables horizontally using a shared column as the key column. Output should have only those rows from "table_1" for which the value in the key column is present in both tables and all the rows from "table_2" Choose the correct SQL command that can accomplish the same.

LEFT JOIN

INNER JOIN

OUTER JOIN

MERGE

Verified Answer
Correct Option - a

To get all Infosys Certified Databricks Analyst Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in