Mainframe Interview Questions

There are some differences:

COBOL II supports structured programming by using in line Performs and explicit scope terminators. It introduces new features (EVALUATE, SET. TO TRUE, CALL BY CONTEXT, etc). It permits programs to be loaded and addressed above the 16-megabyte line .  It does not support many old features (READY TRACE, REPORT-WRITER, ISAM, etc.). It offers enhanced CICS support.

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HAVING selects GROUPs which match the criteria specified

PCT (Program Control Table) - Defines each transaction containing a list of valid transaction identifiers (transid) where each transaction is paired with its matching program.

PPT (Program Processing Table) - Contains a list of valid program names and maps and whether a current version is in the CICS region or needs to be brought in as a new copy.

FCT (File Control Table) - Contains a list of files known to CICS, the dataset name and status (closed/open, enable/disabled)

TCT (Terminal Control Table)- A list of the terminals known to CICS.

 -1 indicates the field is null

 0 indicates the field is not null

 -2 indicates the field is truncated

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

They are DEFINE CLUSTER, DATA and INDEX.

It can be done by setting the record length’s size to more than half of the page’s size.