Transactions differences

What are the differences between No_Transaction and Local_Transaction

Why we are using No_Transactions for General insert,update and delete .
Why we are using Local_Transaction for Batach insert,update and Delete.

if i will use oppositely what happen ???

Please tell me one stupid company has asked this question

No_TX – Auto Commit
LOCAL_TX – Explicit Commit


general Insert/ update / delete → we can use either Local ( explicit commit) or No_transaction ( auto commit)

batch insert/ update /delete → we have to go with local transaction only, if not the tables will not be listed. More info read → 6.5 JDBC adapter user guide under documentation\Adapters_and_eStandards\JDBC_6-5