C2090-320 Online Practice Questions and Answers

Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

A. COPY

B. REORG

C. STOSPACE

D. BACKUP SYSTEM

You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved.

How can you accomplish this?

A. Bind your application with ISOLATION(UR)

B. Bind your application with ISOLATION(CS)

C. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)

D. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

A. REAL

B. BIGINT

C. DECIMAL

D. INTEGER

While DSN is running, which of the following commands CANNOT be successfully executed?

A. -STOP DB2

B. -START DB2

C. -TERM UTILITY

D. -DISPLAY UTILITY

In order to run a DB2 program, the user issues the following commands:

TSO prompt: READY

USER enters: DSN SYS(SSTR)

USER enters: RUN PROGRAM(MYPROG)

USER enters: END

What is the result?

A. DB2 does not allow these commands

B. DSN command can not be used to run a program

C. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session

D. Start a DSN session with system parameters SSTR, run a program and end the DSN session

Given the tables:

Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A.

A. B.

C. D.

Which authorizations can change the value of the subsystem parameter SYSADM using the -SET SYSPARM command? (Choose two.)

A. SYSADM

B. SECADM

C. SYSCTRL

D. Installation SYSADM

E. Installation SYSOPR

In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

A. SYSIBM.SYSINDEXES

B. SYSIBM.SYSINDEXPART

C. SYSIBM.SYSINDEXSTATS

D. SYSIBM.SYSINDEXSPACESTATS

Which of the following automatically maintains historical versions of data over several years?

A. A partitioned-by-range table

B. A partitioned-by-growth table

C. A system-period temporal table

D. An application-period temporal table

Which of the following statements will create an application-period temporal table?

A. B. C. D.