Sawaal
  • Home/
  • Searching for %

 Searching for "%"

Q:

What does it mean if the null indicator has -1, 0, -2?

Answer

 -1 indicates the field is null


 0 indicates the field is not null


 -2 indicates the field is truncated

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 SQLCA?

Answer

- SQLCA stands for SQL Communication Area


- SQLCA is a structure of variables which are updated after every SQL statement’s execution


- Exactly only one SQLCA need to be provided to an application that contains executable SQL statements


- SQLCA is not applicable to JAVA application


- More than one SQLCA need to be provided for FORTRAN application

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:

What is SPUFI?

Answer

SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How does DB2 use multiple table indexes?

Answer

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

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is DBRM? What it contains? When it will be created?

Answer

- DBRM stands for Database Request Module


- The output of pre-compile process is represented as DBRM


- The SQL statements are extracted from the host language by the pre-compiler

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview