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.	-1
B.	0
C.	1
D.	2
Answer» C. 1

Discussion

No Comment Found

Related MCQs

In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________
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 _____________
The ‘LAST_INSERT_ID()’ is tied only to the ‘AUTO_INCREMENT’ values generated during the current connection to the server.
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______________?$
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________$
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.$
When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns ____________