Which control statement is used to indicate the utility that an editing operation is to be performed?
GENERATE
MODIFY
ALTER
MEMBER
Which is the utility that is used to convert data formats, rearrange input fields and change logical record length?
IEBDS
IEHLIST
IEHPROGM
IEBGENER
The datasets that are to be compared must satisfy which of the following conditions?
Both the datasets must have same block size
Both the datasets must have same record length
Both the datasets must have same block size and record length
No condition is required
Must tape dataset definitions include VOL=SER specifications?
Yes
Only for Uncataloged datasets
No
Only for cataloged datasets
Which control statement is used for reformatting the records that are sorted using SORT function?
SORTOUT
OUTREC
DFSORT
AFTER
If a(+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?
As the (0) generation
As the (+1) generation
As the (-1) generation
Without generation number
DECLARE TABLE in DCLGEN is necessary.
True
False
environments which can access DB2
TSO
CICS
IMS
BATCH
ALL THE ABOVE
What is sqlcode -922...?
SELECT statement has resulted in retrieval of more than one row
AUTHORIZATION FAILURE
consistency tokens in the DBRM and the load module are different
NONE OF THE ABOVE
How many clustering indexes can be defined for a table..?
one
two
six
four