Leads4pass > IBM > IBM DB2 > C2090-320 > C2090-320 Online Practice Questions and Answers

C2090-320 Online Practice Questions and Answers

Questions 4

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)

Buy Now
Questions 5

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

Buy Now
Questions 6

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

A. None

B. SYSADM

C. SECADM

D. EXECUTE

Buy Now
Questions 7

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

Buy Now
Questions 8

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

Buy Now
Questions 9

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

Buy Now
Questions 10

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)

Buy Now
Questions 11

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');

Buy Now
Questions 12

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

Buy Now
Questions 13

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

Buy Now
Exam Code: C2090-320
Exam Name: Apache Spark 1.6 Developer
Last Update: Oct 20, 2024
Questions: 123
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$49.99

VCE

$55.99

PDF + VCE

$65.99