QUESTION: 17

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?

Bind your application with ISOLATION(UR)
Bind your application with ISOLATION(CS)
Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

Answer(s): D

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/ db2z_accesscommitteddata.html

Show Answer Next Question

QUESTION: 18

Given the following CREATE VIEW statement and sample data; your login id is “ROGER”.
What will be the result for this query?

Answer(s): C

Show Answer Next Question

QUESTION: 19

Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

TRUNCATE employee;
DELETE FROM employee;
DELETE FROM employee WHERE…;
TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

Answer(s): B

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_delete.html

Show Answer Next Question

QUESTION: 20

Which of the following is a characteristic of a stand-alone utility?

It can only be executed using JCL
It can only be executed by a user with SYSADM
It can only be executed if no other utilities are running
It can only be executed in a non-data sharing environment

Answer(s): A

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/ db2z_invokestandaloneutl.html

Show Answer Next Question

Free IBM C2090-320 Exam Questions (page: 11)

QUESTION: 17

Reference:

QUESTION: 18

QUESTION: 19

Reference:

QUESTION: 20

Reference:

C2090-320 Exam Discussions & Posts