how does the defining of a stored procedure effect the size of a DB2 data base

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

Question Posted / harish

2 Answers
10569 Views
Accenture, I also Faced
E-Mail Answers

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 are bind parameters in db2?

0 Answers

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers

List out the data types available.

0 Answers

What is DB2 (IBM Database 2)?

3 Answers

What is a result table?

1 Answers

How is a typical db2 batch pgm executed?

0 Answers

Explain transactions, commits and rollbacks in DB2.

3 Answers

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers RBS,

How will you delete duplicate records from a table?

7 Answers Google,

What is release/acquire in bind?

0 Answers

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers

For more DB2 Interview Questions Click Here