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
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 |
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 |
What is release/acquire in bind?
List out the data types available.
cursor with hold explain ?
What is the syntax required for the creation of a cursor?
Is ibm db2 open source?
What does the CHECK Utility do ?
What is reorg?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
can any body explain about plan and pakage in detail....
what is the responsibility of the construction superintendent
What is isolation level?
What's the maximum number of volumes that can be added to a STOGROUP?