Oracle Application Express 5: Developing Web Applications — Question 32

Robert has a form page, Page 5, on the EMP table. He has defined two validations.
Validation 1 checks that P5_MGR is not null.
Validation 2 checks that the employee selected in P5_MGR has a job of PRESIDENT or MANAGER.
How can Robert prevent the employee job validation (Validation 2) from firing when the P5_MGR is NOT NULL validation (Validation 1) has failed?

Answer options

• A. Set stop processing to Yes for the P5_MGR is NOT NULL validation (Validation 1)
• B. Ensure Validation 1 is listed before Validation 2
• C. Add a server-side condition of P5_MGR is NOT NULL to the employee job validation (Validation 2)
• D. Set Always Execute to No for the P5_MGR employee job validation (Validation 2)

Correct answer: C

Explanation

The correct answer is C because adding a server-side condition ensures that Validation 2 only runs when P5_MGR is NOT NULL. Option A would stop processing for Validation 1 but does not prevent Validation 2 from running. Option B only addresses the order of validations without affecting their execution. Option D would prevent Validation 2 from executing altogether, which is not the goal.