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 |
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What information is held in SYSIBM.SYSCOPY?
How can we retrieve the total number of records in RPG & CLLE?
What is the logical entity between plan and Package?
Explain how can you do the explain of a dynamic sql statement?
What is dbrm in db2 database?
What do you need to do before you do EXPLAIN?
Can we use select * statement in cobol program without giving field names ???
What is an asychronous write?
What should be specified along with a cursor in order to continue updating process after commit?
What is a Resource Control Table(RCT)? Describe its characteristics.
How to handle null values in db2