Examveda

The statement that exits a labeled flow-control construct is . . . . . . . .

A. DESCRIBE

B. LEAVE

C. LOOP

D. RETURN

Answer: Option B

Solution (By Examveda Team)

This question is about how to exit a loop in MySQL. Loops are used to repeat a block of code several times. Let's understand the options:
Option A: DESCRIBE - This command is used to get information about a table's structure. It doesn't help us exit a loop.
Option B: LEAVE - This is the correct answer! The LEAVE statement allows you to exit a loop or a procedure.
Option C: LOOP - This keyword starts a loop in MySQL. It doesn't exit a loop.
Option D: RETURN - This statement is used to exit a stored procedure and optionally return a value. It's not specifically for exiting loops.
So, the answer is Option B: LEAVE

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous