N

Nitin Gupta • 1.72K Points
Master 

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

  • (A) MEMORY
  • (B) InnoDB
  • (C) FEDERATED
  • (D) Falcon
  • Correct Answer - Option(A)
  • Views: 158
  • Filed under category MySQL
Explanation by: Nitin Gupta 
The configuration options for the storage engine ‘MEMORY’ are always built. The runtime options for ‘MEMORY’ are also always enabled. For the others, runtime options are explicitly enabled byt specifications.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Stored programs improve database security.

Q. The statement used to create a trigger is . . . . . . . .

Q. The numerical values of two ___ of the ___ table can be easily subtracted using SQL Subtraction Operator.

Q. Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?

Q. x'ffff' in decimal is . . . . . . . .

Q. What is the meaning of "EMPTY SET" in the following MySQL command? SELECT fname, lname, person_id FROM person WHERE lname=’s’; /* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec

Q. Views are not updatable.

Q. What returns a string containing an error message?

Q. In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is . . . . . . . .

Q. Which statement exits a labeled flow-control construct?

Learn All MySQL MCQs

Question analytics