Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 10447 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Can SQL statements/queries be included in a copybook?
What is precompiler in db2?
What are the functions of Bind?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
what is the name of the default db2 catalog database?
What is lock escalation in db2?
What does db2 mean?
How will you delete duplicate records from a table?
How can the duplicate values be eliminated from db2 select?
List out the buffer pools in db2
what is db2 restart?
What do you need to do before you do EXPLAIN?
COBOL 
