Verified of C2090-614 test materials and bible for IBM certification for IT candidates, Real Success Guaranteed with Updated C2090-614 pdf dumps vce Materials. 100% PASS DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) exam Today!
2021 May C2090-614 Study Guide Questions:
Q11. Given the following CREATE TABLE statement: Which statement is correct?
A. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
B. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
C. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
D. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
Answer: C
Q12. Given the following output: Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
A. EXPLAIN_FROM_DATA
B. EXPLAIN_FROM_ACTIVITY
C. EXPLAIN_FROM_SECTION
D. EXPLAIN_FROM_CATALOG
Answer: B
Q13. Consider the following statement:
Which indexes should be created for optimal query performance?
A. CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);
B. CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
C. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);
D. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname);
Answer: C
Replace C2090-614 exams:
Q14. 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
Q15. What is the default user workload class that is created for each database table?
A. DEFAULT_USER
B. SYSUSERDEFAULTWLM
C. SYSDEFAULTUSERWORKLOAD
D. SYS_DEFAULT_USER_WORKLOAD
Answer: C
Q16. Which statement about compression dictionaries is FALSE?
A. Page-level dictionaries are stored in hidden rows within the table.
B. Table-level dictionaries are stored in hidden rows within the table.
C. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.
D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.
Answer: D
High quality C2090-614 preparation labs:
Q17. What is the preferred method for reclaiming unused storage in a DMS table space?
A. Perform an ALTER TABLESPACE...REDUCE operation.
B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.
C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
D. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.
Answer: C
Q18. Which statement about Range-Clustered Tables (RCTs) is correct?
A. More logging is required compared to similarly-sized regular tables.
B. More buffer pool memory is required to store the table's B+ index structure.
C. Space is pre-allocated and reserved for use by the table even when records do not yet exist.
D. More maintenance is required since indexes must be updated after every insert, update, or delete operation.
Answer: C
Q19. Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?
A. Data class, work class, and a limit
B. Data class, action class, and a threshold
C. Service subclass, action class, and a limit
D. Service subclass, work class, and a threshold
Answer: D
Q20. The following statement was used to create a table space named TBSP1 in a non-partitioned database:
Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?
A. ALTER TABLESPACE tbsp1 REDUCE MAX
B. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK
C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);
D. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;
Answer: C