Which of the following are requirements for MyISAM binary portability?

Question

Options

• ABoth machines must use the same operating system.
• BDatabase and table names must use lowercase format.
• CBoth machines must use IEEE floating-point format or contain no floating-point columns.
• DBoth machines must use two's-complement integer arithmetic.

• A
  20% (5)
• B
  80% (20)

Explanation

MyISAM tables and InnoDB tablespaces are binary portable from one host to another if two conditions are met: Both machines must use two's-complement integer arithmetic. Both machines must use IEEE floating-point format, or else the tables must contain no floating- point columns (FLOAT or In practice, those two conditions pose little restriction. Two's-complement integer arithmetic and IEEE floatingpoint format are the norm on modern hardware. A third condition for InnoDB binary portability is that you should use lowercase names for databases and tables. This is because InnoDB stores these names internally (in its data dictionary) in lowercase on Windows. Using lowercase names allows binary portability between Windows and Unix. To force the use of lowercase names, you can put the following lines in an option file: lower_case_table_names=1

No community discussion yet for this question.