When no AUTO_INCREMENT value has been generated during the current con – McqOptions

MCQOPTIONS

1.	When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns ____________.
A.	2
B.	1
C.	0
D.	-1
E.	None of these
Answer» D. -1

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.