DB2 10.1 DBA for Linux, UNIX, and Windows (000-611) Free Practice Test

Question 1

When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

A. They are automatically dropped.

B. They are marked as "Move Pending."

C. They are automatically moved to the new table space.

D. They are marked as "Dropped Pending."

Correct Answer: D

Question 2

Where are column mask definitions stored?

A. In the system catalog

B. In the table space metadata

C. In the database configuration file

D. In the table definition

Correct Answer: A

Question 3

If the following command is executed:

Which statement is true?

A. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.

B. If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.

C. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1

D. Rejected records will be inserted into the table SCHEMA2.E1

Correct Answer: D

Question 4

What information can be obtained by analyzing EXPLAIN data?

A. Index use, work load, and join methods

B. Access type, index use, and work load

C. Join methods, index use, and access type

D. Work load, access type, and join methods

Correct Answer: C

Question 5

Which table space is NOT created by default when the CREATE DATABASE command is executed?

A. SYSTOOLSSPACE

B. TEMPSPACE1

C. USERSPACE1

D. SYSCATSPACE

Correct Answer: A

Question 6

Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?

A. SECADM

B. SQLADM

C. SYSADM

D. DBADM

Correct Answer: A

Question 7

Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?

A. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;

B. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE
STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;

C. ALTER TABLEPACE my_ts MANAGED BY DATABASE;
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;

D. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;

Correct Answer: A

Question 8

Which statement is NOT true about a database restore operation?

A. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.

B. A table space restore operation must be done offline.

C. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.

D. A table space is not usable until the restore operation completes successfully.

Correct Answer: B

Question 9

How is the time that an agent waits for log records to be flushed to disk calculated?

A. LOG_END_TIME divided by TOTAL_COMMITS

B. LOG_WRITE_TIME divided by TOTAL_COMMITS

C. LOG_FLUSH_TIME divided by TOTAL_COMMITS

D. LOG_WAIT_TIME divided by TOTAL_COMMITS

Correct Answer: B

Welcome to TestSimulate

IBM DB2 10.1 DBA for Linux, UNIX, and Windows (000-611) Free Practice Test