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

Q. To reactivate indexes the command used is _________________

View solution

Q. Which of these has higher priority?

writes, reads

View solution

Q. How many of the following implement the default scheduling property of MySQL?

MyISAM, MERGE, MEMORY

View solution

Q. Which statement issues a lock on tables?

View solution

Q. Reading from a table does not change it.

View solution

Q. To how many of these does the LOW_PRIORITY modifier apply to?

DELETE, INSERT, LOAD DATA, REPLACE

View solution

Q. The number of tables among the following for which HIGH_PRIORITY have an effect are _________________

MyISAM, MEMORY, MERGE

View solution

Q. The number of tables for which DELAYED works is _________________

MyISAM, MEMORY, ARCHIVE, BLACKHOLE

View solution

Q. Find the odd one out in terms of scheduling policies.

View solution

Q. The use of table level locks is always useful in MyISAM tables.

View solution

Q. Which table is preferred when there are many updates?

View solution

Q. Accessing data from which of these is faster?

memory, disk

View solution

Q. Which system variable controls the size of the table cache?

View solution

Q. Which status indicator assesses how effective the table cache is?

View solution