Which of the following statements about stored procedures is TRUE?

Posted by: Pdfprep Category: C2090-616 Tags: , ,

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

Leave a Reply

Your email address will not be published.