Question

Which mode tells not to cache query results?

(a) 0

(b) 1

(c) 2

(d) 3

The question was posed to me by my school principal while I was bunking the class.

This interesting question is from Administrative-Level Optimizations topic in section Query Optimization of MySQL

Answer 1

Right option is (a) 0

Explanation: The have_query_cache system variable is used to check whether there is support for query cache. The mode ‘0’ tells not to cache the query results or to retrieve the cached results.