Database "Start Transaction"

Help
1

If I use the Start Transaction Activity, does that mean I can:

INSERT into table X select * from table Y
DELETE * from table X

without worrying about another process adding to table X while I’m operating on it?

Does that make sense?

2

I think what I’m asking, using the “Start Transaction” database acitivity, is the operation atomic?