Which of the following statements about stored procedures is TRUE?

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: B

Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/

com.ibm.db2.luw.sql.ref.doc/doc/r0023603.html

Latest C2090-616 Dumps Valid Version with 63 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments