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 |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is correlation names?
what are the SQL codes u freequently got?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is the purpose of using commit?
What is an intent lock?
How can we define a table? How can we apply SEARCH ALL on it ?
What is meant by concurrency?
What is the difference between spufi and qmf?
Can we install 2 different versions of Db2 on same mainframe?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?