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 |
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Why select is not preferred in embedded sql programs?
What os does db2 run on?
can we update the table by using cursors can anyone post the query?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is release/acquire in bind?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
How to find the maximum value in a column in the db2 database?
What information is held in SYSIBM.SYSCOPY?
how to copy the host variables from ps file into cobol program other than include statement
Explain about mirror activator disk mirroring?
Before you give the explain statement, what are the prerogatives?