1. |
You wish to create a function named FIND_LOWEST that returns the lowest insurance rate (in dollars and cents) for your customer, given the customer's home state. Which code snippet would be valid for the CREATE...AS portion of your function?
Please select the best answer.
|
|
A. |
CREATE FIND_LOWEST (CUSTOMER_STATE IN VARCHAR2) RETURN NUMBER AS |
|
B. |
CREATE FUNCTION FIND_LOWEST (HOMESTATE IN VARCHAR2) RETURN NUMBER(10,2) AS |
|
C. |
CREATE FUNCTION FIND_LOWEST (STATE_NAME IN VARCHAR2) RETURN NUMBER AS
|
|
D. |
CREATE FUNCTION FIND_LOWEST (STATE_NAME IN VARCHAR2) RETURN RATE_NUMBER AS
|