It is impossible to pass IBM C2090-614 exam without any help in the short term. Come to Ucertify soon and find the most advanced, correct and guaranteed IBM C2090-614 practice questions. You will get a surprising result by our Renovate DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) practice guides.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-614 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-614 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-614-exam-dumps.html
Q51. The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?
A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
B. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
C. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
Answer: D
Q52. What statement regarding Asynchronous index cleanup (AIC) is correct?
A. AIC removes all invalid index entries that refer to the attached partitions.
B. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
C. AIC activates a newly attached partition after the index entries have been synchronized.
D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).
Answer: B
Q53. What is a benefit of multi-temperature data storage?
A. It helps reduce redundant I/O.
B. It helps improve data compression ratios.
C. It helps reduce storage costs for infrequently accessed data.
D. It helps identify data access patterns to aid in storage planning.
Answer: C
Q54. A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?
A. Automatic storage (AS) table spaces
B. System managed space (SMS) table spaces
C. Database managed space (DMS) table spaces that use FILE containers
D. Database managed space (DMS) table spaces that use RAW containers
Answer: A
Q55. The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?
A. CREATE INDEX salary_bonus_idx ON employee (salary, bonus)
B. CREATE INDEX bonus_salary_idx ON employee (bonus, salary)
C. CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER
D. CREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER
Answer: C
Q56. Which statement about data type mappings is true in a federated system?
A. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.
B. Data types can be mapped in both directions between a remote and local data type.
C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.
D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.
Answer: B
Q57. Which command(s) should be used to drop database partition 10 from a database named MYDB?
A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY;
B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;
C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET;
D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb;
Answer: B
Q58. What must be done to convert a populated base table to a multidimensional clustering (MDC) table?
A. Export the data, create an MDC table, and then import or load the data into the MDC table.
B. Execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table.
C. Create an MDC table and then move the data in the base table to the MDC table with the db2move command.
D. Export the data, execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table, and then import or load the datainto the converted table.
Answer: A
Q59. Where is the HADR_TARGET_LIST configuration parameter set?
A. On the primary database only.
B. On all participating databases.
C. On the tertiary standby databases.
D. On the auxiliary standby databases only.
Answer: B
Q60. Which tool provides the simplest method for monitoring buffer pool hit ratios?
A. The BP_HITRATIO administrative view.
B. The BP_WRITE_IO administrative view.
C. The MON_GET_BUFFERPOOL table function.
D. The MON_GET_PAGE_ACCESS_INFO table function.
Answer: A