List of top Computer Science and IT Engineering Questions on Database Management Systems asked in Karnataka PGCET

Which of the following is true about the SQL JOIN operation?