Cause all that matters here is passing the IBM C2090-611 exam. Cause all that you need is a high score of C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows exam. The only one thing you need to do is downloading Ucertify C2090-611 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 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. Which statement about updating index statistics with the RUNSTATS command is true?
A. It requires a full index scan.
B. It can be accomplished by sampling the index.
C. It must be executed against all indexes for the table.
D. It cannot be accomplished without scanning the associated table.
Answer: B
Q42. 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
Q43. 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
Q44. What are two types of DB2 Discovery requests that a client can make? (Choose two.)
A. KNOWN
B. SEARCH
C. LOOKUP
D. TRUSTED
E. UNTRUSTED
Answer: A,B
Q45. What is the MAX_LOG database configuration parameter used for?
A. To limit how many log files a single transaction can span.
B. To limit the percentage of primary log space a running transaction can consume.
C. To limit the total number of primary and secondary log files a database can consume.
D. To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.
Answer: B
Q46. Which statement regarding snapshot administrative views and snapshot monitor table functions is true?
A. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions.
B. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.
C. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition.
D. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.
Answer: D
Q47. Which statement is true about Insert Time Clustering (ITC) tables?
A. An existing MDC table can be converted to an ITC table.
B. ITC tables have similar characteristics to MDC tables, except they don't use block indexes.
C. The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.
D. ITC tables are created with the CREATE TABLE command by specifying the ORGANIZE BY INSERT TIME clause.
Answer: D
Q48. Which system command can be used to locate and return only ADM4500W messages from the
DB2 diagnostics log file?
A. db2pd
B. db2diag
C. db2trace
D. db2fmtdiag
Answer: B
Q49. Table TAB_A resides within table space TBSP_1.
Which statement is correct?
A. TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.
B. A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read thedata that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.
C. The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will beappended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.
D. The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also bebuilt using the INCREMENTAL indexing mode, the concurrency of table TAB_A will be maximized for any applications that wish to access thetable.
Answer: A
Q50. What are two purposes of the SET INTEGRITY statement? (Choose two.)
A. To bring a table out of "Set Integrity Pending" state by performing the required integrity processing on the table.
B. To bring a table out of "Set Integrity Pending" state by performing only check constraint processing on the table.
C. To bring a table out of "Set Integrity Pending" state without performing the required integrity processing on the table.
D. To bring a table out of "Set Integrity Pending" state by performing only referential integrity constraint processing on the table.
E. To bring a table out of "Set Integrity Pending" state by performing only referential integrity and check constraint processing on the table.
Answer: A,C