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

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,


Why select is not preferred in embedded sql programs?

0 Answers  


What os does db2 run on?

0 Answers  


can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,


In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,


What is release/acquire in bind?

0 Answers  


EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  


What information is held in SYSIBM.SYSCOPY?

1 Answers  


how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


Explain about mirror activator disk mirroring?

0 Answers  


Before you give the explain statement, what are the prerogatives?

0 Answers  


Categories