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

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  


What is correlation names?

1 Answers  


what are the SQL codes u freequently got?

2 Answers   Logica CMG,


If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,


What is the purpose of using commit?

0 Answers  






What is an intent lock?

3 Answers  


How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  


What is meant by concurrency?

1 Answers  


What is the difference between spufi and qmf?

0 Answers  


Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


Categories