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.

Tables related with a foreign key are called delete-connected because a deletion in the primary key table can affect the contents of the foreign key table.

Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary key values in their related tables. And updates of primary key values may require changes in foreign key values to maintain referential integrity.

A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production environment.

Never. Such processing could produce duplicate values violating entity integrity. Primary keys must be updated one at a time.

A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the inner select passes to the where criteria for the outer select.

The database descriptor, DBD is the DB2 component that limits access to the database whenever objects are created, altered or dropped.

The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between each free page. Free space allows room for the insertion of new rows.

Table1 has the following data – Book Chapter ---------------------------- DB2 Retrieval DB2 Updates DB2 Locking COBOL File processing COBOL Working storage JCL Job statement CICS Maps What will be the result of the querySELECT BOOK FROM TABLE1 GROUP BY BOOK HAVING COUNT(*) > 1a.DB2, COBOL, JCL, CICSb.DB2, COBOLc.JCL, CICSd.DB2, CICSe.JCL, COBOLDB2, COBOL

Which of the following DB2 components allows references to Oracle and DB2 databases in a single query? A. DB2 Query Patroller B. DB2 Warehouse Manager C. DB2 Relational Connect D. DB2 Connect Enterprise Edition

If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.

If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.

How will you call DSN8CC in a COBOL program and why it is used.