The maximum number of indexes on MyISAM table is __________. – McqOptions

MCQOPTIONS

1.	The maximum number of indexes on MyISAM table is __________.
A.	more than 1
B.	0
C.	1
D.	2
E.	None of these
Answer» B. 0

Discussion

No Comment Found

Related MCQs

In a single table (with 10 columns) join query the number of values needed to examine per column is __________.<br>
Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.<br><pre class="prettyprint lang-c">SELECT Person.i1, Employee.i2<br> FROM Person INNER JOIN Employee<br> WHERE Person.i1 = Employee.i2;<br></pre>
How many of the following shared tablespaces is bound by the OS file size limit?<br>MyISAM, InnoDB, TRANSACTION
In a single table (with 10 columns) join query the number of values needed to examine per column is __________.
The data rows of a MyISAM table are stored in __________.
The maximum number of indexes on MyISAM table is __________.
Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.
The slow query log is written as __________.
For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________.
If a column contains 7 values and 6 distinct values, the cardinality is __________.