Question 157 – Database-Management-System
May 14, 2024Question 429 – Database-Management-System
May 14, 2024Question 245 – Database-Management-System
The join operation can be defined as
Correct Answer: A
Question 255 Explanation:
→ The join operation can be defined as a cartesian product of two relations followed by a selection.
→ A SQL JOIN clause is used to combine rows from two or more tables, based on a related column between them.
Different Types of SQL JOINs
1. INNER JOIN: Returns records that have matching values in both tables
2. LEFT (OUTER) JOIN: Return all records from the left table, and the matched records from the right table
3. RIGHT (OUTER) JOIN: Return all records from the right table, and the matched records from the left table
4. FULL (OUTER) JOIN: Return all records when there is a match in either left or right table
a cartesian product of two relations followed by a selection
a cartesian product of two relations
a union of two relations followed by cartesian product of the two relations
a union of two relations
Subscribe
Login
0 Comments