Examcollection offers free demo for C2090-611 exam. "DB2 10.1 DBA for Linux, UNIX, and Windows", also known as C2090-611 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-611 exam, will help you answer those questions. The C2090-611 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-611 exams and revised by experts!


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-611 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-611 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-611-exam-dumps.html

Q61. Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

A. db2set ALT_DIAGPATH=/db2data/db2dump2

B. db2set SECONDARY_DIAGPATH=/db2data/db2dump2

C. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

D. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

Answer: C


Q62. Which statement regarding compression for temporary tables is true?

A. Temporary tables can only be compressed using adaptive compression.

B. Temporary tables can only be compressed using classic row compression.

C. Compression for temporary tables can be dynamically enabled and disabled.

D. The DB2 optimizer automatically decides to use classic row compression or adaptive compression for temporary tables.

Answer: B


Q63. 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 using the DB2 problem determination tool.

C. By examining the contents of the system catalog.

D. By examining the DB2 administration notification log file.

Answer: A


Q64. What authority is required to create, alter and drop workload management objects?

A. SYSADM

B. SECADM

C. WLMADM

D. ACCESSCTRL

Answer: C


Q65. Which statement about DB2 aggregate registry variables is true?

A. An aggregate registry variable that is explicitly set by an application cannot be overwritten.

B. An aggregate registry variable overrides any corresponding explicitly set registry variable.

C. A registry variable that is explicitly set by an application can only be overwritten by aggregate registry variable.

D. A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.

Answer: D


Q66. If the following command is executed:

Which statement is true?

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

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

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

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

Answer: A


Q67. What can be used to provide input to the Design Advisor?

A. An XML file.

B. A query workload file.

C. The database configuration file.

D. The database manager configuration file.

Answer: B


Q68. 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_WAIT_TIME divided by TOTAL_COMMITS

C. LOG_WRITE_TIME divided by TOTAL_COMMITS

D. LOG_FLUSH_TIME divided by TOTAL_COMMITS

Answer: C


Q69. Which statement is NOT true about a database restore operation?

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

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

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 database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.

Answer: A


Q70. What authority must be held to create a trusted context?

A. DBADM

B. SQLADM

C. SECADM

D. CONNECT

Answer: C