The MySQL SQL/PSM statement used to test for a condition and then direct which blocks of code should be run depending on the outcome of the test is ________.
A)DECLARE
B)BEGIN
C)IF...THEN...ELSE...END IF
D)REPEAT

Question

Quizplus · Accepted Answer

The IF...THEN...ELSE...END IF statement tests for a condition and can direct which blocks of code should be run depending on the outcome of the test. DECLARE is used to define variables, BEGIN is used to start a block of code, and REPEAT is used to create a loop.

The MySQL SQL/PSM Statement Used to Test for a Condition