DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) Free Practice Test

Question 1

A database named TEST and a storage group named SG_1 were created with these statements:

an error was produced.Why did the error occur?

A. New storage paths cannot be added to existing storage groups.

B. The storage group IBMSTOGROUP cannot be dropped because it is a system-defined storage group.

C. The storage group SG_1 was not the current default storage group at the time a new storage path was being added to it.

D. The current default storage group cannot be dropped.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

A. EXPLAIN_FROM_SECTION

B. EXPLAIN_FROM_ACTIVITY

C. EXPLAIN_FROM_CATALOG

D. EXPLAIN_FROM_DATA

Correct Answer: A

Question 3

What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?

A. AUDIT

B. CONTEXT

C. EXECUTE

D. VALIDATE

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

What must you do before an online table space backup operation can be performed?

A. Create one or more tables in the table space.

B. Create an incremental backup image of the table space.

C. Create a full database backup image.

D. Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.

Correct Answer: C

Question 5

On which two operating systems can DB2 pureScale run? (Choose two.)

A. HP-UX

B. Windows

C. AIX

D. Linux

E. Solaris

Correct Answer: C,D

Question 6

Which item is NOT eligible for adaptive compression?

A. Temporary tables

B. Inline LOB values

C. Indexes

D. Base tables

Correct Answer: A

Welcome to TestSimulate

IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) Free Practice Test