adplus-dvertising
frame-decoration

Question

Which option turns on the –extended-insert?

a.

–opt

b.

–opti

c.

–op

d.

–optimize

Answer: (a).–opt

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Similar Questions

Discover Related MCQs

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

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

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

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

Q. To reactivate indexes the command used is _________________

Q. Which of these has higher priority?

writes, reads

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

MyISAM, MERGE, MEMORY

Q. Which statement issues a lock on tables?

Q. Reading from a table does not change it.

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

DELETE, INSERT, LOAD DATA, REPLACE

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

MyISAM, MEMORY, MERGE

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

MyISAM, MEMORY, ARCHIVE, BLACKHOLE

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

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

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

Q. Accessing data from which of these is faster?

memory, disk

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

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

Q. In MySQL, the default size of the key buffer in MB is _________________

Q. The system variable to maintain InnoDB log buffer size is _________________