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 |
what is the name of the default db2 catalog database?
What is the difference between TYPE 1 index & TYPE 2 index
What is a LIKE table and how is it created?
What is cursor stability?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
max number of columns in a db2 table?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
Can one database have multiple instances?
How could one combine a set of incremental image copies into a single copy?
What is the syntax for FETCH in DB2 ?
What is the usage of open cursor command?
i want to delete 20th million record how ?