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


Please Help Members By Posting Answers For Below Questions

How to view db2 table structure?

603


What is check constraint in db2?

625


What is release/acquire in bind?

667


How to run db2 command in windows?

660


What is the difference between bind and rebind in db2?

868






define clustering index.

629


Why do we need reorg in db2?

572


How can we read records for specific member in CL? AND rpg?

243


What action db2 takes when a program aborts in the middle of a transaction?

671


What is the default page size of buffer pools?

658


How to access db2 tables in mainframe?

623


Explain what are the various isolation levels possible?

616


How do I delete a column in db2?

688


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

632


What is a db2 schema?

772