how does the defining of a stored procedure effect the size
of a DB2 data base
A) it increases the size of a data base
B) it decreases the size of a data base
C) it does not effect the size of the data base
D) it changes the table space structures
Answers were Sorted based on User's Feedback
Answer / alucard
a - it increases the size of a data base.
Because a stored proc is called from a program and the
stored proc is stored along with the DB..hence the size of
the db increases.
Is This Answer Correct ? | 9 Yes | 4 No |
Answer / guest
C. It does not effect the size of the database. The stored
procedure is not associated with any other object in the
database.
Is This Answer Correct ? | 4 Yes | 0 No |
How to solve S0C7 abend with out using DISPlay in 10 mins?
What is a bind in db2?
Why cursor is used in db2?
What os does db2 run on?
What is meant by AUTO COMMIT?
What is the function of the Data Manager?
When is the authorization check on DB2 objects done - at BIND time or run time?
What happens to the PLAN if index used by it is dropped?
define clustering index.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What do you mean by commit and rollback?
What is data manager?