The value of recently generated sequence number can be obtained by ___ – McqOptions

MCQOPTIONS

1.	The value of recently generated sequence number can be obtained by ____________.
A.	LATEST_INSERT_ID()
B.	INSERT_ID()
C.	LAST_INSERT_ID()
D.	INITIAL_INSERT_ID()
E.	None of these
Answer» D. INITIAL_INSERT_ID()

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.