Q. The storage engine in MySQL that provides foreign key support is ___________

View solution

Q. What is the property of InnoDB that enforces foreign key relationships stay intact?

View solution

Q. Which mode exists at both global level and session-specific level?

View solution

Q. Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

View solution

Q. The largest value to which the variable ‘max_allowed_packet’ can be set is ______________

View solution

Q. Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?

View solution

Q. The keyword used with UNION that retains duplicate rows is ___________

View solution

Q. The search mode that uses natural language search as a subroutine is ____________

View solution

Q. For what can the FULLTEXT indexes be created for?

View solution

Q. A FULLTEXT index can be created for multiple columns.

View solution

Q. For which of these storage engines are configuration options always built?

View solution

Q. The storage engine for which the runtime options are always enabled is ______________

View solution

Q. The most important configurable resource for MyISAM is ______________

View solution

Q. Which system variable enables mysqld to keep more tables open simultaneously?

View solution

Q. How can a view refer to multiple tables?

View solution

Q. What is the mantissa in -1.58E5?

View solution

Q. What is the precision of BIGINT?

View solution

Q. How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

View solution

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