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
How can you count the number of rows from a table tab?
What is coalesce in db2?
What does db2 mean?
Explain in brief how does db2 determine what lock-size to use?
What is rct?
Define check constraint.
Are view updateable?
On which levels locks can be applied?
Explain various types of locks in db2?
What is the default page size of buffer pools?
What is the reason behind not using select * in embedded sql programs?
What do you mean by storage group (stogroup)?
Is it possible using max on a char column?
Which component is responsible for db2 startup and shutdown?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?