The LAST_INSERT_ID() is tied only to the AUTO_INCREMENT values gen – McqOptions

MCQOPTIONS

1.	The LAST_INSERT_ID() is tied only to the AUTO_INCREMENT values generated during the current connection to the server.
A.	False
B.	True
C.	NA
D.	NA
E.	NA
Answer» C. NA

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.