In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment – McqOptions

MCQOPTIONS

1.	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 _____________.
A.	1
B.	12
C.	14
D.	13
E.	None of these
Answer» E. None of these

Discussion

No Comment Found

Related MCQs

The AUTO_INCREMENT sequences normally begin at __________.
The value of recently generated sequence number can be obtained by ____________.
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________.
When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns ____________.
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 _____________.
The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number _____________.
Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 100. The next row added will have value _____________.
The LAST_INSERT_ID() is tied only to the AUTO_INCREMENT values generated during the current connection to the server.