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
- 9841 Views
- Accenture, I also Faced
- E-Mail Answers
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
Is db2 a mainframe?
How does db2 sample database connect?
What are the benefits of using the db2 database?
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?
How many databases can be created inside an instance in db2 ?
What is rct?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are packages in db2?
How to check table size in db2 sap?
If I have a view which is a join of two or more tables, can this view be updateable?
What is schema in db2?
How to fetch the last row from the table in SQL (db2)?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a db2 collection?
What is the maximum No of rows per page?
