Answer 1

It depends on your commands. Commands which manipulate the database obviously have an influence on following commands. For example you want to update an value but this value was not inserted before, so nothing gets updated. Afterwards you insert the value. Now there is the not updated value in yozr database.
the same happens for Select if you do not use views. You select some values and update afterwards then the old values are in your select result