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 the usage of open cursor command?

0 Answers  


explain about index with examples

2 Answers   Syntel,


What does CURRENTDATA option in bind indicate

1 Answers   IBM,


How do I add a column to a table in db2?

0 Answers  


what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,






What is a synonym? How is it used?

2 Answers  


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


What is rebind in db2?

0 Answers  


How to compare data between two tables in db2?

0 Answers  


How to find the number of rows in a db2 table?

0 Answers  


What do you mean by cursor?

0 Answers  


how can you access index

4 Answers   IBM, Tech Mahindra,


Categories