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



how does the defining of a stored procedure effect the size of a DB2 data base A) it increases th..

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

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases th..

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

Post New Answer

More DB2 Interview Questions

What is release/acquire in bind?

0 Answers  


List out the data types available.

0 Answers  


cursor with hold explain ?

1 Answers   Verizon,


What is the syntax required for the creation of a cursor?

1 Answers  


Is ibm db2 open source?

0 Answers  


What does the CHECK Utility do ?

1 Answers  


What is reorg?

0 Answers  


What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  


can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,


what is the responsibility of the construction superintendent

0 Answers   Almco,


What is isolation level?

4 Answers  


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


Categories