Assessment: DB2 10.1 Fundamentals (A2090-610) Free Practice Test

Question 1

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 2

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?

A. Lock exchange

B. Lock escalation

C. Lock conversion

D. Lock promotion

Correct Answer: B

Question 3

Which statement about triggers is true?

A. A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a table.

B. A trigger performs actions to capture details about an activity like a join operation against multiple tables.

C. A trigger is designed to return specific types of values and contains executable code.

D. A trigger is designed to return specific types of values but contains no executable code.

Correct Answer: A

Question 4

Which statement regarding triggers is true?

A. Triggers cannot be modified, they must be dropped and recreated with new definitions.

B. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.

C. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.

D. Triggers can only be fired one time per statement irrespective of the number of rows affected.

Correct Answer: A

Question 5

A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?

A. SELECT name, COUNT(*) AS transactions FROM sales

B. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

C. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

D. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions

Correct Answer: C

Question 6

If a table named MY_TAB contains 100 rows and the following statement is executed:

How many rows will be updated?

A. 0

B. 1

C. 99

D. 10

Correct Answer: D

Question 7

An SQL function named DEPT_INFO was created as follows:

What is the correct way to use this function in a query?

A. SELECT dept_info(dept_id, dept_name)

B. SELECT dept_id, dept_name FROM dept_info()

C. SELECT TABLE dept_id, dept_name FROM dept_info()

D. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

Correct Answer: D

Question 8

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 9

Which statement is true regarding constraints?

A. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.

B. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.

C. A table can only have one unique key constraint.

D. A table can have multiple primary key constraints.

Correct Answer: B

Question 10

Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?

A. Self-tuning memory manager

B. Workload manager

C. pureScale

D. Data partitioning feature

Correct Answer: B

Welcome to TestSimulate

IBM Assessment: DB2 10.1 Fundamentals (A2090-610) Free Practice Test