IBM DB2 10.1 Fundamentals Set 4

1.

Which product replaced the Control Center used in versions prior to DB2 v10?

IBM Data Studio IBM Administrator IBM Data Manager IBM Command Center

2.

Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?

SELECT * FROM employee WHERE salary < 100000

SELECT salary FROM employee WHERE salary > 100000

SELECT salary FROM employee WHERE salary > 100,000.00

SELECT * FROM employee WHERE salary GREATER THAN 100000

3.

Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set in ascending order by average departmental salary?

SELECT workdept, AVG(salary) FROM employee ORDER BY workdept GROUP BY 2

SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY 2

SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER BY 2

SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2

4.

A table named DEPARTMENT contains the following data: What will happen?

The statement will fail because a subquery cannot be used in an UPDATE statement. The statement will fail because the result set produced by the subquery will contain more than one row. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPTvalue for the update operation. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPTvalue for the update operation.

5.

What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?

Lock wait Lock timeout Lock escalation Lock conversion

6.

What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

Lock exchange Lock promotion Lock escalation Lock conversion

7.

When is an INTENT EXCLUSIVE (IX) lock required?

When a transaction intends to read or change data. When a transaction intends to change but not read data. When a transaction intends to read but not change data. When a transaction intends to change the system catalog.

8.

The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?

Concurrent application processes from performing any operations on the table. Concurrent application processes from performing any read-only operations on the table. Concurrent applications processes that are running under the cursor stability (CS) isolation level fromperforming read-only operations on thetable. Concurrent applications processes that are running under the uncommitted read (UR) isolation level fromperforming read-only operations onthe table.

9.

What factor influences lock conversion/promotion?

Lock size Number of locks Lock mode needed Available real storage

10.

Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?

Read Stability (RS) Cursor Stability (CS) Repeatable Read (RR) Uncommitted Read (UR)

IBM DB2 10.1 Fundamentals Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM DB2 10.1 Fundamentals Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner