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

Related MCQs

• For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is                      
• If a column contains 7 values and 6 distinct values, the cardinality is                      
• Incase the indices values are larger, index is created for these values of the index. This is called
• FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;
• A key of type                         is generated which is used later to join ngrams with their heads and tails in the reducer phase.
• The slow query log is written as
• The maximum number of indexes on MyISAM table is                      
• Which of the following function is used to find the column count of the particular resultset?
• Which of the following adds marginal sums to an existing table?
• Which of the following compute analysis of variance table for fitted model?