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
Answer Posted / 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 |
Post New Answer View All Answers
What is db2?
What action db2 takes when a program aborts in the middle of a transaction?
Describe major components of db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How and when does the db2 enforces the unique key?
What is the use of with ur in db2?
What is check constraint. Explain with example.
What is null indicator in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is the use of db2 optimizer?
What is ibm db2 connect?
What is a db2 cursor?
What is reorg?
Define predicate?
What is a db2 table?