C2090-320 Online Practice Questions and Answers

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)

Consider the following question: "What is the average salary by sex within education level?" An occasional uncommitted record can be tolerated in the average.

Which of the following is the most appropriate isolation level for this?

A. UR

B. RR

C. CS

D. RS

Which privilege or authority is required to use the DSN command?

A. None

B. SYSADM

C. SECADM

D. EXECUTE

In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

A. A unique key

B. A foreign key

C. A primary key

D. A duplicate key

E. A secondary key

How can a stored procedure be invoked?

A. Via an SQL SELECT statement

B. Via a CALL statement using SPUFI

C. Directly via a RUN PROGRAM command

D. Via a CALL statement from within an application program

Which of the following coupling facility structures are used by DB2 in a data sharing environment?

A. List structure, DB2 logs, and group buffer pools

B. Work file database, list structure, and virtual buffer pools

C. Lock structure, shared communications area, and group buffer pools

D. Lock structure, shared communications area, and bootstrap data sets

Which command displays the DB2 catalog level and migration mode?

A. DSNC DISPLAY

B. MODIFY irImproc, STATUS

C. -DISPLAY GROUP DETAIL

D. -DISPLAY DATABASE (DSNDB06)

Given the following table:

Which of the following INSERT statements will be successful?

A. INSERT INTO EMPSAMP (empno, name, salary, deptno, level, hiretype, hiredate) VALUES(2,'Mary Smith', 35000.00, 11, `Associate', `existing','05-06-2016');

B. INSERT INTO EMPSAMP (`Mary Smith', 35000.00, 11, `Associate', `existing','05-06-2016'); C. INSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, `Associate', `existing','05-06-2016');

D. INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES(`Mary Smith', 35000.00, 11, `Associate');

Which catalog table would you query in order to determine the relevant statistics for an index?

A. SYSIBM.SYSKEYS

B. SYSIBM.SYSFIELDS

C. SYSIBM.SYSCOLUMNS

D. SYSIBM.SYSINDEXSTATS

Which statement about an application-period temporal table is TRUE?

A. It has SYSTEM_TIME defined

B. It has an end column defined using WITH DEFAULT NULL

C. It must have the index clause BUSINESS_TIME WITHOUT OVERLAPS

D. It has a begin column defined as TIMESTAMP(6) NOT NULL or DATE NOT NULL