IBM Assessment: DB2 10.1 Fundamentals - A2090-610 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?

A. Intent Exclusive (IX) B. Exclusive (X) C. Share (S) D. Update (U)

Discussion 0

Correct Answer: C Vote an answer

Question 2

What is used in conjunction with a foreign key to define a relationship between two tables?

A. Primary key B. Check constraint C. Partitioning key D. Unique constraint

Discussion 0

Correct Answer: A Vote an answer

Question 3

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A. Cursor stability (CS) B. Repeatable read (RR) C. Read stability (RS) D. Uncommitted read (UR)

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which type of table should you use if you want to define specific time periods when data is valid?

A. Materialized query table B. System-period temporal table C. Application-period temporal table D. Declared global temporary table

Discussion 0

Correct Answer: C Vote an answer

Question 5

User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?

A. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE CASCADE rule. B. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE RESTRICT rule. C. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE RESTRICT rule. D. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE CASCADE rule.

Discussion 0

Correct Answer: D Vote an answer

Question 6

What is a function of a table check constraint?

A. To provide a method of avoiding duplicate entries for a column. B. To enforce relationships between tables by checking the existence of rows in one table against another. C. To ensure that XML columns are properly populated in an associated XML table space. D. To provide a method of ensuring a column's values are within a specific range.

Discussion 0

Correct Answer: D Vote an answer