C2090_611 questions • Exam prepare

Exam contains 115 questions

Page 19 of 20

Question 109 🔥

Which statement about triggers is FALSE?

Which database solution meets these requirements?

A. A statement-level trigger fires only once for each SQL statement.

B. A trigger's code block can be executed either before or after a triggering event.

C. A row-level trigger fires once for each row that is affected by a triggering event.

D. A table-level trigger fires once for each table that is affected by a triggering event.

Discussion of the question

Question 110 🔥

Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database?

Which database solution meets these requirements?

A. DB2_INDEX_DEFAULT

B. DB2_EXTENDED_OPTIMIZATION

C. DB2_INDEX_PCTFREE_DEFAULT

D. DB2_ENABLE_AUTOCONFIG_DEFAULT

Discussion of the question

Question 111 🔥

A table named CUSTOMER and an index named CUST_IDX were created as follows:Which operation would you expect to see in the access plan diagram produced?

Which database solution meets these requirements?

A. NLJOIN

B. HSJOIN

C. IXSCAN

D. TBSCAN

Discussion of the question

Question 112 🔥

Which command will enable automatic reorg on a database?

Which database solution meets these requirements?

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

Discussion of the question

Question 113 🔥

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

Which database solution meets these requirements?

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.

Discussion of the question

Question 114 🔥

Which statement about DB2 aggregate registry variables is true?

Which database solution meets these requirements?

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.

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_611

Exam contains 115 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us