Exam Code: C2090-611 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10.1 DBA for Linux, UNIX, and Windows
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-611 Exam.


♥♥ 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

Q41. What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

A. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the droppedtable.

B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover thedropped table.

C. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command withthe RECOVER DROPPED TABLE option to restore the database and recover the dropped table.

D. Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.

Answer:


Q42. Which statement is correct for a user who holds SECADM authority?

A. A user who holds SECADM authority can only grant and revoke database object privileges.

B. A user who holds SECADM authority can grant and revoke all database level authorities and database object privileges.

C. A user who holds SECADM authority can only grant and revoke DBADM and SECADM database level authorities.

D. A user who holds SECADM authority can only grant and revoke label based access control (LBAC) security labels.

Answer: B


Q43. What authority is required to grant a user ACCESSCTRL authority?

A. DBADM

B. SQLADM

C. SECADM

D. DATAACCESS

Answer: C


Q44. What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

A. CPU cycles

B. Elapsed time, in milliseconds

C. Processing instructions performed

D. Timerons

Answer: D


Q45. Which action can a DBA take to retrieve bufferpool metrics information?

A. Ensure the MON_OBJ_METRICS configuration parameter is enabled and query the

BP_HITRATIO table function.

B. Ensure the MON_ACT_METRICS configuration parameter is enabled and query the

BP_HITRATIO administrative view.

C. Ensure the MON_OBJ_METRICS configuration parameter is enabled and query the

MON_GET_BUFFERPOOL table function.

D. Ensure the MON_ACT_METRICS configuration parameter is enabled and query the

MON_GET_BUFFERPOOL administrative view.

Answer: C


Q46. What is an informational constraint?

A. A constraint that defines a relationship to a federated object.

B. A constraint that is used by the optimizer but is not enforced.

C. A constraint that provides Information to the RUNSTATS utility.

D. A constraint that is created from information supplied to the design advisor.

Answer: B


Q47. Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)

A. The table is not a system temporary table.

B. The table contains a sufficient amount of data.

C. A table-level compression dictionary does not already exist for the table.

D. A page-level compression dictionary does not already exist for the table.

E. The table does not have any indexes defined on it that have not been enabled for compression.

Answer: B,C


Q48. Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?

A. db2pd

B. db2dart

C. db2look

D. db2mimic

Answer: C


Q49. The following commands are executed against a database named MY_DB, which has been configured to use archival logging:

Which statement is true?

A. Upon completion of the Load, the table T1 is placed into "Backup Pending" state.

B. Upon completion of the Load, a backup image of table T1 is automatically generated.

C. After a Restore and Rollforward operation, table T1 would be marked unavailable and can only be dropped.

D. After a Restore and Rollforward operation, the loaded data is stored into a copy-image file and table T1 is fully available.

Answer: C


Q50. If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON

(Inactive) Which statement is true?

A. Self-tuning is occurring only on the instance memory area.

B. The memory tuner is actively tuning the memory on the system.

C. Self-tuning is not occurring because it is waiting for the database to be recycled.

D. Self-tuning is not occurring because there are less than two memory consumers enabled.

Answer: D