Answer / s
Information about recovery.
|Is This Answer Correct ?||5 Yes||3 No|
When Can you be sure that a query will return only one row?
Mention the location where the output received from explain statement is stored.
What is reorg and runstats in db2?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
What else is there in the PLAN apart from the access path?
How do you prepare a COBOL + DB2 program from coading till execution ?
What is dbrm? When it will be created?
How do you check for a null value in a db2 column?
What are the various data types available in db2?
My SQL is not performing well. Describe how will you fine tune it?
What information is held in SYSIBM.SYSCOPY?
What is package versioning? Please give an example.