if you alter a table to add a column and make it unable to accept null, what happens to the existing rows?

Answer 1

it will not be displayed because it needs to be in exact order

Answer 2

nothing happens to existing row but affects only new item added in the table, that is altered row