Please Answer Questions Follow The Prompts Below

;

call sp1();

SELECT * FROM EMPLOYEE ORDER BY ID;
A . 1 MOHAN
2 RON
B. 1 MOHAN
2 RON
3 RANJAN
C. 1 MOHAN
3 RANJAN
D. 1 MOHAN

View Answer

Answer: A

Explanation

https://docs.snowflake.com/en/sql-reference/transactions.html#scoped-transactions

Scoped Transactions

A stored procedure that contains a transaction can be called from within another transaction. For example, a transaction inside a stored procedure can include a call to another stored procedure that contains a transaction.

Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction. Snowflake calls these “autonomous scoped transactions” (or simply “scoped transactions”). The starting point and ending point of each scoped transaction determine which statements are included in the transaction. The start and end can be explicit or implicit. Each SQL statement is part of only one transaction. An enclosing ROLLBACK or COMMIT does not undo an enclosed COMMIT or ROLLBACK.