What is QUIESCE?

Correct Answer: SQL statement gets executed when we open cursor

Correct Answer: - If the table structure is changed ( a field is added ), the program will have to be modified - Program might retrieve the columns which it might not use, leading on I/O over head - The chance of an index only scan is lost

Correct Answer: The number of distinct values for a column is called index cardinality DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data

Correct Answer: USING HOST VARIABLE we can pass data from COBOL to DB2

Correct Answer: A DB2 bind is a process that builds an access path to DB2 tables

Correct Answer: The simplest DB2 index is the B-tree and the B-tree's top page is called the root page The root page entries represent the upper range limits of the index and are referenced first in a search

Correct Answer: DB2 acts as the participant and CICS acts as a co-ordinator

Correct Answer: Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing

Correct Answer: READNEXT reads the next record from a browse operation for any of the three VSAM files

Correct Answer: - NOHANDLE is an option that can be specified along with abnormal condition during program execution - When the exception occurs, no action is performed during execution of NOHANDLE command - The abnormal condition is ignored, even the EXEC CICS HANDLE condition exist - The abnormal condition is also ignored when EXEC CICS IGNORE condition is tested - The previous HANDLE CONDITION for other commands will not be effected with NOHANDLE option