User Details form page is page 1 in your application. On this page the end user is required
to provide his Name and Address details- You need to create a validation that requires the
end user to enter a province if the country is not the United States (US). Which action needs
to be performed?
A.
Create a validation of type SQL and enter the following in the validation method; SELECT
1 FROM CUSTOMERS WHERE COUNTRY= ‘US’ AMD PROVINCE IS NULL
B.
Create a validation of type PL/SQL Function Returning Boolean and enter the following in
the validation method: BEGIB IF :Pi_COUNTRY = ‘US’ AMD : Pl_PROVINCE IS NULL
THEN RETURM FALSE; ELSE RETURN TRUE; END IF; END;
C.
Create a validation of type PL/SQL Function Returning Boolean and enter the following in
the validation method; BEGIN IF :P1_COUNTRY != ‘US’ AND ; Pl_PROVINCE IS NULL
THEN RETURN FALSE; ELSE RETURN TRUE; END IF; END;