Multiple choice technology databases

The JOIN is a SQL keyword used to ...

  1. update database table.

  2. verify that the inserted data is correct.

  3. select data from 2 or more tables related by common attribute (table column).

  4. delete data from database table.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

JOIN is the SQL keyword used to retrieve data from two or more tables based on a related column between them. It combines rows from different tables that satisfy specified conditions. JOIN is not used for updating, verifying data correctness, or deleting operations - those use UPDATE, validation logic, and DELETE respectively.

Keep practicing — related questions