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

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.

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

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

A Cartesian product results from a faulty query. It is a row in the results for every combination in the join tables.

The LIKE keyword allows for string searches. The % sign is used as a wildcard.

SUBSTR is used for string manipulation with column name, first position and string length used as arguments. Eg. SUBSTR (NAME, 1 3) refers to the first three characters in the column NAME.

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.

Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence of a value.

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.