[2026] IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows

문제1

Which of the following table types is NOT supported by the load utility?

A. A Range Partitioned table

B. A Global Temporary table

C. A Temporal table

D. A Multidimensional Clustering table

정답: B

문제2

Which statement about primary keys is true?

A. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.

B. A primary key accepts one, and only one, NULL value.

C. A table can have multiple primary keys.

D. A unique index, with matching columns of the primary key, must be created before a primary key can be created.

정답: A

문제3

What are two types of DB2 Discovery requests that a client can make? (Choose two.)

A. LOOKUP

B. UNTRUSTED

C. KNOWN

D. SEARCH

E. TRUSTED

정답: C,D

문제4

How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)?

A. By using the change history event monitor.

B. By examining the contents of the system catalog.

C. By using the DB2 problem determination tool.

D. By examining the DB2 administration notification log file.

정답: A

문제5

Which authorities can be audited with the AUDIT statement?

A. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.

B. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.

C. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.

D. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.

정답: A

문제6

If the following statement is executed:

What indexes will be created for table TAB1?

A. 1 dimension-block index and 1 composite-block index

B. 3 dimension-block indexes and 1 composite-block index

C. 1 dimension-block index and 3 composite-block indexes

D. 3 dimension-block indexes and 3 composite-block indexes

정답: B

IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows - A2090-611무료 덤프문제 풀어보기