SQL Control Structures Quiz

Which of the following SQL control structures allows you to execute a series of statements based on a condition?

• IF-THEN

• CASE

• LOOP

• All of the above

In SQL, which statement is used to exit a loop or block of code prematurely?

• BREAK

• CONTINUE

• EXIT

• RETURN

Which of the following SQL control flow statements is used to iterate over a set of statements multiple times?

• IF-THEN

• WHILE

• CASE

• EXIT

Which of the following statements can be used in SQL to execute one or more statements when a condition is true, and another set of statements if the condition is false?

• CASE

• IF-ELSE

• LOOP

• GOTO

Which SQL statement is used to define a conditional logic block in PL/SQL or T-SQL?

• CASE

• BEGIN-END

• IF-ELSE

• TRY-CATCH

What is the function of the "CONTINUE" statement in SQL loops?

• To terminate the current loop

• To skip the current iteration and move to the next iteration of the loop

• To restart the loop from the beginning

• To break out of a loop completely

In which of the following cases is the "GOTO" statement in SQL most commonly used?

• To control the flow based on complex conditions

• To jump to a specific label or line of code within the stored procedure

• To create a nested loop

• To execute a function

In SQL Server, which keyword is used to handle exceptions in a TRY...CATCH block?

• THROW

• EXCEPTION

• HANDLE

• ERROR

What is the output of the following SQL code? DECLARE @x INT = 10; IF @x > 5 PRINT 'Greater'; ELSE PRINT 'Smaller';

• Greater

• Smaller

• Error

• No Output

Which control structure in SQL is used for performing conditional logic but allows for multiple conditions to be checked?

• CASE

• IF

• SWITCH

• LOOP