IBM Assessment: DB2 10.1 Fundamentals - A2090-610 Exam Practice Test

A. REFERENCES

B. CALL

C. EXECUTE

D. USAGE

A. Time-period

B. Application-period

C. System-period

D. Bitemporal

A. SELECT state_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY state_cd;

B. SELECT region_cd, COUNT(*)
FROM states
GROUP BY region_cd
ORDER BY COUNT(*);

C. SELECT state_cd, COUNT(*)
FROM states
ORDER BY COUNT(*);

D. SELECT region_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY COUNT(*);

A. An error will be returned and the operation will fail.

B. The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.

C. A warning will be returned and the unique index INDX1 will become the index for the primary key.

D. The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.

A. AIX

B. iOS

C. Windows

D. z/OS

A. IBM Data Studio

B. IBM Data Manager

C. IBM Administrator

D. IBM Command Center

A. To improve performance of some queries by allowing index-only access.

B. To override the limit on index key columns.

C. To combine two or more indexes to create a single unique index.

D. To further enforce the uniqueness of index values.

A. SELECT dept_info(dept_id, dept_name)

B. SELECT TABLE dept_id, dept_name FROM dept_info()

C. SELECT dept_id, dept_name FROM dept_info()

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