Which type of loop requires a BREAK statement to stop executing?
Which type of loop requires a BREAK statement to stop executing?
A LOOP statement typically runs indefinitely until a BREAK statement is encountered. In contrast, FOR, REPEAT, and WHILE loops have inherent terminating conditions. The FOR loop iterates a set number of times, the REPEAT loop executes until a specific condition is met, and the WHILE loop continues as long as its condition remains true. Therefore, the correct answer is LOOP.
https://docs.snowflake.com/en/developer-guide/snowflake-scripting/loops#terminating-a-loop BREAK is required in a LOOP but is not necessary in WHILE, FOR, and REPEAT.
B. BREAK is required in a LOOP but is not necessary in WHILE , FOR , and REPEAT .
I would say answer D.
https://docs.snowflake.com/en/developer-guide/snowflake-scripting/loops