Sawaal
  • Home/
  • Searching for st

 Searching for "st"

Q:

Explain the difference among the EXEC LINK, EXEC XCTL and Cobol II static call statements in CICS?

Answer

- Use a COBOL II CALL statement to invoke a subprogram. This method is transparent to CICS, which sees only the one load module. 


- EXEC LINK is similar to a call; it invokes a separate CICS program and ends with a RETURN to the invoking program


- EXEC XCTL which transfers control to another CICS program and does not get control 


back. 


COBOL II allows for static calls which are more efficient than the LINK instruction which establishes a new run-unit. 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

When does the SQL statement gets executed when you use cursor in the application programming?

Answer

SQL statement gets executed when we open cursor


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

Answer

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


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is the self-referencing constraint?

Answer

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is the difference between Cursor Stability and Repeatable Read isolation levels?

Answer

CURSOR STABILITY:


- CS is a row level locking


- Acquires an exclusive lock on the row that is to be updated


- When the control is moved to the next updatable row, the lock is released


REPEATABLE READ:


- RR is a page level locking


- Acquires an exclusive lock on the entire page which is the source of row availability


- When the control is moved to the next updatable page the lock is released

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is COPY PENDING status?

Answer

- A status occurs when image copy on a table needs to be taken


- The table is available only for queries and can not be updated


- COPY PENDING status can be removed by taking away the image copy or by using REPAIR utility

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is Mainframe Testing?

Answer

Mainframe Testing is similar to client-server applications testing, but you have to know how to operate basic TSO and ISPF commands and menus, view mainframe files, look at and use SDSF or other output tool, log on CICS and transactions, use FTP or another transfer protocol, submit the batch job - it's for QA testing of mainframe applications.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How do you display last 5 records in DB2?

Answer

SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview