Which of the following concerning the COND parameter are true on EXEC statement level? (2 answers)

  1. The COND parameter always indicates that if its condition is met, the step is NOT executed.

  2. When adding the COND parameter to an EXEC statement that calls a procedure, this COND

  3. With the COND parameter, we can only check return codes.

  4. The COND parameter can check the return codes of multiple steps, but as soon as one of


Correct Option: B,D

AI Explanation

To answer this question, we need to understand the purpose and usage of the COND parameter on EXEC statements.

Option A) The COND parameter always indicates that if its condition is met, the step is NOT executed. This statement is incorrect. The COND parameter allows you to specify a condition that determines whether the step should be executed or not. If the condition is met, the step is executed. If the condition is not met, the step is bypassed.

Option B) When adding the COND parameter to an EXEC statement that calls a procedure, this COND This statement is correct. When adding the COND parameter to an EXEC statement that calls a procedure, the COND parameter allows you to specify a condition that determines whether the procedure should be executed or not. If the condition is met, the procedure is executed. If the condition is not met, the procedure is bypassed.

Option C) With the COND parameter, we can only check return codes. This statement is incorrect. The COND parameter can be used to check different types of conditions, not just return codes. It allows you to specify a condition based on return codes, condition codes, or other criteria.

Option D) The COND parameter can check the return codes of multiple steps, but as soon as one of This statement is correct. The COND parameter can be used to check the return codes of multiple steps in a job or procedure. If the condition is met for any of the specified steps, the subsequent steps are bypassed.

Therefore, the correct answers are B) When adding the COND parameter to an EXEC statement that calls a procedure, this COND and D) The COND parameter can check the return codes of multiple steps, but as soon as one of.

Find more quizzes: