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
- 10367 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 |
What technique is used to retrieve data from more than one table in a single SQL statement?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
define clustering index.
What is catalog database in db2?
can any body explain about plan and pakage in detail....
What is the SQL Communications Area and what are some of its key fields?
How to fetch the uncommited data from table ?
What do you mean by commit and rollback?
What is explain in db2?
Can we use select * statement in cobol program without giving field names ???
What is a host variable?
COBOL 
