How will u send data from a cobol file to db2 table?

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

Correct Answer: An application plan or package is generated by the bind to define an access path

Correct Answer: Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted

Correct Answer: Go to file-aid copy optionEnter the from dataset to be copied and to dataset to which you want to copygo to options Enter 0 at Initial records to skip fieldThen enter 3 at the no of records to skip field and 1 to no of records to selectpress enter and PF3

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

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: - 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: SQL statement gets executed when we open cursor

Correct Answer: A QUIESCE flushes all DB2 buffers on to the disk This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency

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