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 the difference between cursor stability and repeatable read isolation levels?
What parameters are used to control the free space in DB2?
How can you count the number of rows from a table tab?
How to retrieve rows from a db2 table in embedded sql?
Define check constraint.
What is a db2 collection?
What is performance tuning db2?
How can record locking be achieved in those DB2 versions which do not support it?
What are concurrency issues?
What does db2 stand for?
What is the difference between using bind () and rebind () methods of naming class?
What is host variable in db2 cobol?
What is the physical storage length of timestamp data type?
What is db2 and what is the use of db2 optimizer?
What is db2 purescale?