What is a DB2 plan?

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: 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: 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: A DB2 bind is a process that builds an access path to DB2 tables

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

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