FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;

[Solved] FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl

Q.	FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;
A.	14
B.	2
C.	1
D.	48
Answer» D. 48
Explanation: in mysql, when the tables are unindexed, the searches are run through all the possible combinations. in this case, the search space is 8 x 6 = 48, the product of the number of rows.

1.6k

Do you find this helpful?

View all MCQs in

No comments yet