Q. Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is . . . . . . .
SELECT tbl_1.i1, tbl_2.i2
FROM tbl_1 INNER JOIN tbl_2
WHERE tbl_1.i1 = tbl_2.i2;
SELECT tbl_1.i1, tbl_2.i2
FROM tbl_1 INNER JOIN tbl_2
WHERE tbl_1.i1 = tbl_2.i2;
✅ Correct Answer: (D)
48
Explanation: This question asks about the number of combinations checked when using an INNER JOIN in a SQL query. Let's break it down: