Database Management Systems (DBMS)
What is the function or purpose of SQL JOIN?
- A. A database structure that improves the speed of data retrieval operations on a table.
- B. A minimal set of attributes that can uniquely identify a record in a table.
- C. The process of organizing database tables to reduce data redundancy and improve data integrity.
- D. An SQL operation that combines rows from two or more tables based on a related column. ✓
Correct answer
D. An SQL operation that combines rows from two or more tables based on a related column.
Explanation
SQL JOIN refers to an SQL operation that combines rows from two or more tables based on a related column.