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

Q. Which table option for MyISAM tables reduces index flushing?

View solution

Q. Which option repairs MyISAM tables automatically after they open?

View solution

Q. The option which delays index flushing for slave server is _________________

View solution

Q. TO enable the compressed client/server protocol the option is _________________

View solution