The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number . . . . . . . .

Solution (By Examveda Team)

This question is about how MySQL handles sequence numbers when you delete all the rows in a table. Here's the breakdown:

Imagine a table like a list where each row has a unique number. This number is used to identify each row, kind of like a name tag.

When you delete all the rows, you're essentially erasing the entire list. Now, if you add a new row, MySQL will give it the next available sequence number. Since all the old rows are gone, the new row will get the number that would have been used for the next row if you hadn't deleted everything.

In our case, the table had 10 rows, so the next available number is 11.

Therefore, the correct answer is Option A: 11