DB2 10.1 Fundamentals (C2090-610) Free Practice Test

Question 1

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 CASCADE 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 RESTRICT rule.

Correct Answer: B

Question 2

Which statement about a deadlock is true?

A. The victim will read through the lock.

B. The victim will be rolled back.

C. The victim must wait until the holder releases the lock.

D. Both victim and holder are rolled back.

Correct Answer: B

Question 3

What is a function of a table check constraint?

A. To provide a method of ensuring a column's values are within a specific range.

B. To ensure that XML columns are properly populated in an associated XML table space.

C. To enforce relationships between tables by checking the existence of rows in one table against another.

D. To provide a method of avoiding duplicate entries for a column.

Correct Answer: A

Question 4

Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to finish making updates, what isolation level must application APP_B use?

A. Cursor Stability (CS)

B. Uncommitted Read (UR)

C. Read Stability (RS)

D. Repeatable Read (RR)

Correct Answer: B

Question 5

User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?

A. CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200) FOR BIT DATA)

B. CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200))

C. CREATE TABLE parts
(part_no INTEGER,
desc CLOB))

D. CREATE TABLE parts
(part_no INTEGER,
desc CLOB FOR BIT DATA))

Correct Answer: A

Question 6

If a user has been granted SYSCTRL authority, which activities can they perform?

A. Create and drop databases

B. Monitor database performance

C. Backup/copy table spaces

D. Load operations

Correct Answer: A

Question 7

Which of the following privileges allow a user to update the comment on a sequence?

A. COMMENT

B. USAGE

C. ALTER

D. UPDATE

Correct Answer: C

Question 8

Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?

A. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY SALARY
ORDER BY job;

B. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;

C. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job
ORDER BY job;

D. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY MIN(salary), MAX(salary)
ORDER BY job;

Correct Answer: C

Welcome to TestSimulate

IBM DB2 10.1 Fundamentals (C2090-610) Free Practice Test