What is COPY PENDING status?

Correct 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

Correct 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

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

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

Correct 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

Correct 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

Correct Answer: -1 indicates the field is null 0 indicates the field is not null -2 indicates the field is truncated

Correct Answer: It can be done by setting the record length?s size to more than half of the page?s size

Correct Answer: COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program This extra process takes around twice or thrice the time taken normally

Correct Answer: While allocating KSDS Datasets, free space is declared at regular intervals at the time of initial loading This is done because this free space is utilized for keeping the data arranged in sequence physically, even though inserted randomly