What is Mainframe Testing?

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: Static (embedded) SQL: 1In static SQL how database will be accessed is predetermined in the embedded SQL statement 2It is more swift and efficient 3SQL statements are compiled at compile time 4Parsing, validation, optimization, and generation of application plan are done at compile time 5It is generally used for situations where data is distributed uniformly 6EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used 7 It is less flexible Dynamic (interactive) SQL: 1In dynamic SQL, how database will be accessed is determined at run time 2It is less swift and efficient 3SQL statements are compiled at run time 4Parsing, validation, optimization, and generation of application plan are done at run time 5It is generally used for situations where data is distributed non-uniformly 6EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used 7It is more flexible

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

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: - 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

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