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

Q. To minimize disk I/O, which of these should be chosen?

CHAR, VARCHAR

View solution

Q. Avoiding NULL in columns may make queries simpler.

View solution

Q. Which of these can be used to generate hash values?

View solution

Q. IP numbers can be represented as _________________

View solution

Q. Bulk loading is less efficient than single row loading.

View solution

Q. Loading is faster when a table has no indexes than when it is indexed.

View solution

Q. Which is more efficient?

LOAD DATA, INSERT

View solution

Q. Without LOCAL, LOAD DATA is _________________

View solution

Q. Which option turns on the –extended-insert?

View solution