Which of the following statements about stored procedures is TRUE?
A . Stored procedures can be written in SQL PL, but not in the PL/SQL dialect
B . The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another
procedure in a federated database
C . There are three types of stored procedures which can be deployed: SQL procedures, external
procedures, and sourced procedures
D . Two identically-named procedures within a schema are permitted to have exactly the same number of
parameters, but the parameters must have different data types assigned
Answer: C
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/
com.ibm.db2.luw.sql.ref.doc/doc/r0023603.html