PrepAway - Latest Free Exam Questions & Answers

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

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0023603.html


Leave a Reply