In a single table (with 10 columns) join query the number of values needed to examine per column is . . . . . . . .

Solution (By Examveda Team)

This question is about how MySQL joins data from different tables. Imagine you have a table with 10 columns, like a spreadsheet with 10 columns.
When you use a JOIN query, MySQL needs to look at each value in a column of one table to see if it matches a value in a column of another table.
Since we're dealing with a single table, MySQL doesn't need to compare values across different tables. It's like comparing values within the same spreadsheet.
Therefore, MySQL only needs to examine one value per column to complete the join.
So the correct answer is Option A: 1.