adplus-dvertising
frame-decoration

Question

To determine whether query cache is supported by the server the variable is _________________

a.

have_query_cache

b.

have_cache_query

c.

query_cache_have

d.

cache_query_have

Posted under MySQL Database

Answer: (a).have_query_cache

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. To determine whether query cache is supported by the server the variable is _________________

Similar Questions

Discover Related MCQs

Q. Which mode tells not to cache query results?

Q. Which mode tells cache queries that begin with SELECT SQL_CACHE?

Q. Installing more memory into the machine enables to configure larger values for cache server.

Q. Which command is used to remove existing tables or database?

Q. Which command is used to display all the existing tables in a database?

Q. Is duplicate entry of primary key is allowed in SQL?

Q. Is duplicate entry of other attributes are allowed in SQL?

Q. Which is the correct format to store date in the SQL?

Q. Which of the following are the valid “database datatypes” in Mysql?

Q. Which Key is used to link two tables in Mysql?

Q. Which line of the following statements will produce error?

Q. Which compiler is used to execute the structured query language?

Q. Which among the following tags belong to Data definition language?

Q. Which among the following tags belong to Data Manipulation language?

Q. Query Mechanism performs the following functions?

Q. What jobs “Query Optimizer” perform in Mysql?

Q. Which are the two languages used in Mysql?

Q. The users responsible for query processing in database system are ___________

Q. Select the sequence for how the query mechanism works?

Q. Which clause is used to determine “which column to include in the query sets”?