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
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
What is an instance database?
How can deadlocks be resolved?
How can you count the number of rows from a table tab?
What is a plan and package in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Why select is not preferred in embedded sql programs?
Mention some fields that are a part of sqlca.
What is db2 connect?
What is collection in db2 bind?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Give a brief description of db2 isolation levels?
What is a trigger in the db2 database?
When do you specify the isolation level?
Which isolation level provides maximum concurrency?
is it compulsory commitment control in journal?