What is true about stored procedures?
A.
A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters.
B.
A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.
C.
A stored procedure must have at least one executable statement in the procedure body.
D.
A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.
Explanation:
The executable section must contain at least one executable statement. You can include a NULL keyword to fulfill the need to have at least one executable statement in this section.
For example,
BEGIN
NULL;
END
Incorrect AnswersA: Local variables are declared after the IS or AS keyword and before the BEGIN keyword. The DECLARE keyword is not used.
B: It is not required that a Procedure have a parameter. D: You do not use the DELCARE keyword when specifying parameters. The syntax for creating a procedure is:
CREATE [OR REPLACE] PROCEDURE
[parameter1 [mode1] datatype1,
parameter2 [mode2] datatype2,
. . .)]
IS | AS
. . .
BEGIN
. . .
EXCEPTION