Question

Sql query option under Database command can be used to insert, update and delete the sql table in automation anywhere.

Answer 1

It will depend upon the database configuration. Automation anywhere is just providing mouse clicks and keystrokes to the database application.

Thus, from the database point of view, it is exactly the same as if you were performing it manually.

If you require a separate commit step when you employ the database application manually then you obtain it when utilizing AA as well.