a - it increases the size of a data base. Because a stored proc is called

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 / alucard

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

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

What is db2 bind?

1016

Explain about mirror activator disk mirroring?

957

How does coalesce work?

959

Define predicate?

1065

How do I import data from excel to db2?

1011

What is the maximum length of sqlca?

1432

Explain about cursor stability?

981

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1032

How do you stop a db2 database in linux?

957

What is rct?

1164

Define db2.

1064

What are the contents of a dclmgen?

1066

What is sqlca’s maximum length?

1102

Are views updateable?

1070

List down the types of triggers in the db2 database?

962