πŸ“Š Information Retrival Techniques
Q. FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;
  • (A) 14
  • (B) 2
  • (C) 1
  • (D) 48
πŸ’¬ Discuss
βœ… Correct 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.


Explanation by: Mr. Dubey
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.

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
213
Total Visits
πŸ“½οΈ
3 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
83%
Success Rate