Computer Science · Database Management Systems
Consider the following statements regarding the specific outcomes of SQL JOIN operations: Statement 1: An INNER JOIN combines rows by returning only the matching rows from both tables, effectively excluding any unmatched rows. Statement 2: A FULL JOIN combines data by returning all rows from both tables, placing NULL values on the unmatched sides. Which of the options below is correct?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1Statement 1 is false, but Statement 2 is true.
- 2Statement 1 is true, but Statement 2 is false.
- 3Both statements are true.✓
- 4Both statements are false.
Correct answer
Both statements are true.
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Database Management Systems MCQs →Want more practice questions on Database Management Systems?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management Systems