Question
Table A has 5 rows and Table B has 4 rows. Exactly 3 rows in A each match exactly one row in B under a given join condition (the remaining 2 rows in A have no matching row in
- B . What are the row counts returned by a CROSS JOIN of A and B, and a LEFT OUTER JOIN (A LEFT JOIN
- B on that condition, respectively?
More SQL Questions
- SQL Injection can be prevented by all EXCEPT:
- Which SQL aggregate function returns the total number of rows matching a specified condition?
- Which SQL feature allows hierarchical queries (e.g., org chart traversal)?
- A 'view' in SQL is best described as:
- Which SQL keyword is used to eliminate duplicate rows in a query result?
- Table X has a column v with values (1, 2, 2, 3) and table Y has a column v with values (2, 2, 3, 4). How many rows does X FULL OUTER JOIN Y ON X.v = Y.v re...
- Recursive CTEs are mainly used for:
- Which SQL clause is used to group rows?
- ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
- A materialized view differs from a normal view because it:
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)