ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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

Answer & Solution
Correct Answer: Option B
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
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.