MCQOPTIONS
Bookmark
Saved Bookmarks
→
Mysql
→
Data Types in Mysql
→
The AUTO_INCREMENT sequences normally begin at ___..
1.
The AUTO_INCREMENT sequences normally begin at __________.
A.
2
B.
-1
C.
1
D.
0
E.
None of these
Answer» D. 0
Show Answer
Discussion
No Comment Found
Post Comment
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.
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply