Pass4sure 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

Q51. What is the purpose of the Design Advisor?

A. To recommend physical changes to objects in a database.

B. To recommend database configuration parameter changes.

C. To generate profiles for autonomic activity within the database.

D. To generate query definitions required to create usage reports.

Answer: A


Q52. Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

Answer: B


Q53. 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


Q54. Which statement is correct when describing trusted contexts?

A. A trusted context defines a trust relationship for a connection between the database and an external entity.

B. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.

C. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.

D. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.

Answer: A


Q55. Which command will enable automatic reorg on a database?

A. UPDATE DB CFG USING AUTO_REORG ON

B. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON

C. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON

D. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON

Answer: D


Q56. Which statement about the ADMIN_MOVE_TABLE procedure is true?

A. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operationto the target table.

B. The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) table during the move to a user-suppliedstaging table so they can be replayed against the target table when the move is complete.

C. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.

D. If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if the target table isto be created automatically, a name that is different from that of the active table must be specified for the target table.

Answer: C


Q57. 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 marked as "Dropped Pending."

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

Answer: C


Q58. Which statement about insert time clustering tables (ITC) is true?

A. ITC tables cannot be range-partitioned tables.

B. ITC tables are supported in DB2 pureScale environments.

C. Rows of an ITC table are clustered by the time they are inserted into the table.

D. If an ITC table is clustered by one or more user specified dimensions, the specified dimensions must be timestamps.

Answer: C


Q59. 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


Q60. What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?

A. Permission to log in to the database client using telnet.

B. Permission to log in to the database server using telnet.

C. Permission to log in to the database client using secure shell (SSH).

D. Permission to log in to the database server using secure shell (SSH).

Answer: D