Q. The LOCAL capability for LOAD DATA does not need to be enabled explicitly.

View solution

Q. The LOCAL capability for client library is enabled by ______________

View solution

Q. What is the most important configurable resource for MyISAM?

View solution

Q. How many options can be used to control LOCAL capability at runtime?

View solution

Q. A multiple-table delete cannot apply any join.

View solution

Q. The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________

View solution

Q. What is x’ffff’ in decimal?

View solution

Q. What are X’61626364′ and X’61626364′?

View solution

Q. The server sets its default time zone by examining its environment.

View solution

Q. The system variable ‘system_time_zone’ can be reset at runtime.

View solution

Q. The variable which represents the default time zone of the MySQL server is _____________

View solution

Q. The number of options that can be used to control LOCAL capability at runtime is _____________

View solution

Q. If an error occurs during the transaction the troubleshoot is ____________

View solution

Q. The ‘A’ in the ACID property of transactions is _______________

View solution

Q. The ‘C’ in the ACID property of transactions is _______________

View solution

Q. The datatype that means a variable length non binary string is __________

View solution

Q. The date and time datatype that stores time value in ‘hh:mm:ss’ format is ___________

View solution

Q. The spatial datatype used to store a curve is _____________

View solution

Q. OS imposes per process limits on the number of open file descriptors.

View solution

Q. The option that supplies the pathname to root directory of MySQL installation is _____________

View solution