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

View solution

Q. How many of the following shared tablespaces is bound by the OS file size limit?

MyISAM, InnoDB, TRANSACTION

View solution

Q. If a column contains 7 values and 6 distinct values, the cardinality is __________

View solution

Q. For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________

View solution

Q. The slow query log can be used to identify queries that may be performing badly.

View solution

Q. The slow query log is written as __________

View solution

Q. To check how MySQL would execute a SELECT query, which statement is used?

View solution

Q. To perform analysis of key values by the server, the statement used is __________

View solution

Q. Which statement is used to verify optimizer operation?

View solution

Q. Which statement is used to force the optimizer to use tables in a particular order?

View solution

Q. Which of these comparisons is slowest?

View solution

Q. Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?

View solution

Q. Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?

View solution

Q. The optimizer_prune_level is set by default.

View solution

Q. Calculations involving numbers are faster than those involving string.

View solution

Q. To convert an int to string, the function is _________________

View solution

Q. To convert a string to an int, the function is _________________

View solution

Q. To maintain performance of tables having variable length rows, which statement is used?

View solution

Q. Which of these columns are faster?

Variable length, Fixed length

View solution

Q. Which of these take more space?

Variable length columns, Fixed length columns

View solution