Question

Which of the following is an application program defined to DB2 and managed by the DB2 subsystem, used to help limit the number of network calls to run queries against the database?

A. User Defined Function
B. User Defined Type
C. Stored Procedure
D. Trigger

Answer 1

The correct answer is C. Stored Procedure. A stored procedure is an application program defined to DB2 and managed by the DB2 subsystem. It helps limit the number of network calls to run queries against the database, improving performance.

Step-by-step explanation:

The correct answer is C. Stored Procedure.

A stored procedure is an application program defined to DB2 and managed by the DB2 subsystem. It is used to help limit the number of network calls to run queries against the database.

By using a stored procedure, the database management system can process complex operations on the server side, reducing the amount of data sent over the network and improving overall performance.