More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step ? What would be the disposition of this generation now ?
Relative generation numbers are updated only at the end of the job, not at the end of a step. To allocate a new generation, we would be using (+1) with a DISP of ( NEW, CATLG, DELETE ). To refer to this in a subsequent step in the same job, we would again use (+1) but with a DISP of SHR or OLD.
(Continued on next question...)
