Actualtests C2090-611 Questions are updated and all C2090-611 answers are verified by experts. Once you have completely prepared with our C2090-611 exam prep kits you will be ready for the real C2090-611 exam without a problem. We have Most recent IBM C2090-611 dumps study guide. PASSED C2090-611 First attempt! Here What I Did.
♥♥ 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. Which statement about the REORGCHK command is true?
A. It cannot be run against the system catalog.
B. It automatically calls RUNSTATS by default.
C. It cannot be run against multidimensional clustering tables.
D. It automatically calls REORG if it is determined that a reorg is necessary.
Answer: B
Q52. If you are running DB2 in clustered environment, what utility should you use to get the status of cluster?
A. db2istat
B. db2clust
C. db2haicu
D. db2hastat
Answer: C
Q53. Which user-managed file system is required for DB2 pureScale deployments?
A. JFS2
B. NTFS
C. HPFS
D. GPFS
Answer: D
Q54. Which command is used to import connectivity configuration information from a file known as a configuration profile?
A. db2ca
B. db2cfexp
C. db2cfimp
D. db2cfgimp
Answer: C
Q55. You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?
A. Assign the value ON to the DB2_HADR_ROS registry variable.
B. Assign the value ON to the DB2_HADR_SNAP registry variable.
C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
Answer: A
Q56. If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?
A. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.
B. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.
C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.
D. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.
Answer: B
Q57. Which of the following table types is NOT supported by the load utility?
A. A Temporal table
B. A Range Partitioned table
C. A Global Temporary table
D. A Multidimensional Clustering table
Answer: C
Q58. 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
Q59. 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
Q60. Which statement is true regarding the workload management dispatcher?
A. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.
B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.
C. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures.
D. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their workoutside of the DB2 database manager.
Answer: B