Lead4pass C2090-320 dumps updated IBM C2090-320 exam training materials are important and must-have for successful C2090-320 exam passing.

Lead4pass understands you, just updated the latest C2090-320 dumps https://www.leads4pass.com/c2090-320.html containing 123 new Q&A exam training materials, presented in both PDF and VCE formats, welcome to download.

[Free] C2090-320 Dumps Questions, Training Materials 

Free sample questions of C2090-320 free dumps are provided here. 

Question 1:

Given a non-partitioned table space, TS1 is built with BLOCKSIZE ROW, LOCKMAX 1000, and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

A. PAGE

B. TABLE

C. PARTITION

D. TABLESPACE

Correct Answer: C

---

Question 2:

Which of the following are contained in the PLAN_TABLE? (Choose two.)

A. RUNSTATS recommendations

B. Access to LOB values, which are stored separately from the base table

C. Access to the parent or dependent tables needed to enforce referential constraints

D. Whether an index access or table space scan is used for each access to a table

E. The join methods and types that are used, and the order in which DB2 joins the tables

Correct Answer: DE

---

Question 3:

Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?

GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

A. BIND

B. REORG

C. TRIGGER

D. EXECUTE

Correct Answer: D

---

Question 4:

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

A. COPY

B. REORG

C. STOSPACE

D. BACKUP SYSTEM

Correct Answer: D

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

---

Question 5:

Which of the following is NOT TRUE?

A. An index can be created on XML columns

B. Length must be specified for an XML column

C. XML columns can be added to existing tables

D. Triggers can be created on tables with XML columns

Correct Answer: D

---

Question 6:

Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?

A. B. C. D.

Correct Answer: D

---

Question 7:

Which of the following elements is affected by a ROLLBACK statement?

A. LOB table spaces

B. Changes in cursor positioning

C. Acquisition and release of locks

D. Caching of rolled-back statements

Correct Answer: A

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

---

Question 8:

Which statement is TRUE regarding ROLLBACK processing?

A. It only reads active logs

B. It always needs archive logs

C. It can never be processed just from memory

D. It uses output buffers, active and archive logs

Correct Answer: D

---

Question 9:

Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

A. SQLCA

B. SQLDA

C. SQLCODE

D. SQLSTATE

Correct Answer: B

---

Question 10:

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

A. A view

B. A temporal table

C. A created global temporary table

D. A declared global temporary table

Correct Answer: B

---

Question 11:

In a unique referential constraint, which type of key does a foreign key reference?

A. Child key

B. Collation key

C. Parent key

D. Secondary key

Correct Answer: C

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020166.html

---

Question 12:

The following definition for COL1 is given by this statement:

CREATE TABLE… (COL1 BINARY (05))

Which of the following statements will successfully insert data into the table?

A. INSERT INTO… (COL1) VALUES(HEX(`12345\’));

B. INSERT INTO… (COL1) VALUES(BLOB(`12345\’));

C. INSERT INTO… (COL1) VALUES(CHAR(`12345\’));

D. INSERT INTO… (COL1) VALUES(BINARY(`123456\’));

Correct Answer: C

---

Question 13:

If a scrollable cursor is INSENSITIVE, which of the following applies?

A. The cursor is read-only

B. WITH ROWSET POSITIONING is not allowed

C. The select statement must not contain an SQL data change statement

D. The cursor has a sensitivity to changes that are made to the database after the result table is materialized

Correct Answer: A

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/java/src/tpc/ imjcc_tjvsjscr.html

---

Question 14:

You want to reduce lock contention that results from the 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 CONCURRENT ACCESS RESOLUTION (WAITFOROUTCOME)

D. Bind your application with CONCURRENT ACCESS RESOLUTION (USECURRENTLYCOMMITTED)

Correct Answer: D

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

---

Question 15:

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

A. 6

B. 5

C. 4

D. 2

Correct Answer: C

---

The Lead4pass C2090-320 dumps are the ideal C2090-320 exam training material to pass the IBM C2090-320 exam easily using the latest C2090-320 dumps https://www.leads4pass.com/c2090-320.html (PDF+VCE).

Also, remember to practice your C2090-320 exam questions. This is important for a smooth passage.