Which type of JOIN returns records that have matching values in both tables?

A. MySQL

B. MongoDB

C. PostgreSQL

D. Oracle

A. Deletes all rows from a table without logging individual row deletions

B. Deletes only duplicate records

C. Removes table structure

D. Backs up the table

A. GROUP BY

B. ORDER BY

C. HAVING

D. WHERE

A. ORDER BY

B. GROUP BY

C. HAVING

D. FILTER

A. DISTINCT

B. UNIQUE

C. REMOVE

D. EXCLUDE