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
- 10483 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 are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
What is the physical storage length of date data type?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
what is differnece between DROP TABLE & DELETE TABLE .
What are catalog tables in db2?
What do you mean by NOT NULL? When will you use it?
Mention the downsides of page level lock.
how to resolve -811 error. give clear explination
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
COBOL 
