What is a recovery log?
Answer / s
changes to the table are logged in a the active logs and
archived when the active logs become full. In recovery
situations the tablespace is restored using the image copy
and applies the log records from the active/archive logs to
current time.
Is This Answer Correct ? | 4 Yes | 0 No |
How can you find out the # of rows updated after an update statement?
What are concurrency issues?
What is reorg in database?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What is a DBRM, PLAN ?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What db2 400?
what is consistency token
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What is a result table?
cursor with hold explain ?
When do you use the IMAGECOPY?