A

Admin • 833K Points
Coach

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;

  • (A) 14
  • (B) 2
  • (C) 1
  • (D) 48
  • Correct Answer - Option(D)
  • Views: 21
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question asks about the number of combinations checked when using an INNER JOIN in a SQL query. Let's break it down:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.