Computer Science · SQL and Database Queries
Consider two tables, Q1_Sales with 4 rows ('North', 'South', 'East', 'North') and Q2_Sales with 5 rows ('West', 'South', 'West', 'North', 'East'). Calculate the number of rows returned by Query 1 and Query 2 respectively: Query 1: SELECT Region FROM Q1_Sales UNION SELECT Region FROM Q2_Sales; Query 2: SELECT Region FROM Q1_Sales UNION ALL SELECT Region FROM Q2_Sales;
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1Query 1: 9 rows, Query 2: 4 rows
- 2Query 1: 4 rows, Query 2: 7 rows
- 3Query 1: 5 rows, Query 2: 9 rows✓
- 4Query 1: 4 rows, Query 2: 9 rows
Correct answer
Query 1: 5 rows, Query 2: 9 rows
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 SQL and Database Queries MCQs →Want more practice questions on SQL and Database Queries?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · SQL and Database Queries