What is a JOIN operation in MariaDB used for?
a) To combine rows from two or more tables based on a related column
b) To backup a table
c) To encrypt data across multiple tables
d) To aggregate data into a new table
Answer:
a) To combine rows from two or more tables based on a related column
Explanation:
A JOIN operation is used to retrieve data from two or more tables by combining them based on a related column, typically a foreign key.