Hi @Thushar R​ , Your understanding is correct regarding the ACID transactions in delta tables that if any error happens during any transaction, the transaction will be rolled back.

Regarding 2nd question: Databricks does not support transaction blocks similar to one in SQL server.

You can check this document regarding acid transactions in Delta: https://docs.databricks.com/lakehouse/acid.html