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
- 9275 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do I add a column to an existing table in db2?
How would you find out the total number of rows in a db2 table?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Mention some fields that are a part of sqlca.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is table space in db2?
List down the types of triggers in the db2 database?
What is database reorganization?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is dbrm?
How do I create a view in db2?
Explain the contents that are a part of dclgen.
What is the max length of sqlca?
Is db2 a programming language?
What is cursor in dbms?
