Which of the following lines of code is syntactically correct?
a. declare order number; departure date; begin executable statements end
b. declare order number; departure date begin executable statements end
c. declare order number(3); departure date; begin executable statements end;
d. declare order number(2); departure date; begin; executable statements end

The answer is:

c.  

DECLARE

order NUMBER(3);

departure DATE;

BEGIN

executable statements ---

END;

Explanation:

SQL Commands must close with a semicolon to be correctly parsed by the server. This is the cause why the syntax is wrong in:

A. DATE; BEGIN executable statements --- END lacks semicolon in END.

B. DECLARE order NUMBER; departure DATE lacks semicolon after DATE.

D. A. DATE; BEGIN executable statements --- END lacks semicolon in END.

this seems to be in the wrong category. but i'll take some free points my dude

posting this in wrong category will result in people seeing it who won't know the answer.