we provide 100% Guarantee IBM C2090-611 rapidshare which are the best for clearing C2090-611 test, and to get certified by IBM DB2 10.1 DBA for Linux, UNIX, and Windows. The C2090-611 Questions & Answers covers all the knowledge points of the real C2090-611 exam. Crack your IBM C2090-611 Exam with latest dumps, guaranteed!


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


Q62. Where are column mask definitions stored?

A. In the table definition

B. In the system catalog

C. In the table space metadata

D. In the database configuration file

Answer: B


Q63. 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?

A. NLJOIN

B. HSJOIN

C. IXSCAN

D. TBSCAN

Answer: C


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


Q65. What authorization is needed to execute the CREATE MASK statement?

A. SECADM

B. SQLADM

C. SYSADM

D. SYSCTRL

Answer: A


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


Q67. You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

A. Alter the view and add the ENFORCE SELECT clause to the view definition.

B. Drop and recreate the view with the WITH CHECK OPTION clause specified.

C. Alter the view and add the WITH CHECK OPTION clause to the view definition.

D. Create a new view with the same name and the ENFORCE SELECT clause specified.

Answer: B


Q68. Which table space is NOT created by default when the CREATE DATABASE command is executed?

A. USERSPACE1

B. TEMPSPACE1

C. SYSCATSPACE

D. SYSTOOLSSPACE

Answer: D


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


Q70. What does the FLUSH PACKAGE CACHE statement do?

A. It removes all dynamic SQL statements from the package cache.

B. It removes only inactive SQL statements from the package cache.

C. It saves dynamic SQL stored in the package cache to an external file.

D. It causes all SQL statements in the package cache that are currently in use to be recompiled.

Answer: A