My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

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: 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: An application plan or package is generated by the bind to define an access path

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