Practice questions

Question 1: Which of the following is a best choice to load data in real-time with high concurrency?

1. Load
2. Import
3. Ingest
4. db2move

Question 2: Which of the following is TRUE in the case of the Ingest utility?

1. Client-side utility
2. It supports LOB and XML data types
3. It doesn't support DML operations
4. It allows only read-only workload during ingestion

Question 3: Which LOAD command modifier can be used when working with identity column data?

1. IDENTITYRESET
2. IDENTITYOVERRIDE
3. IDENTITYSUPRESS
4. IDENTITYRETAIN

Question 4: Which operation cannot be performed on a table that contains a primary key that is referenced by a foreign key in another table?

1. IMPORT ... INSERT
2. IMPORT ... REPLACE
3. IMPORT ... INSERT_UPDATE
4. IMPORT ... CREATE

Question 5: Which of the following illustrates the proper order in which to use the DB2 data management utilities?

1. RUNSTATS, REORG table...