How can record locking be achieved in those DB2 versions which do not support it?

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

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

Correct Answer: Primary key : a relational database constraint Primary key consists of one or more columns that uniquely identify a row in the table For a normalized relation, there is one designated primary key Unique index: a physical object that stores only unique values There can be one or more unique indexes on a table

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

Correct 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