Exam Code: C2090-614 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614)
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-614 Exam.


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

Q31. After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic? 

A. db2pd 

B. db2dart 

C. db2fodc 

D. db2ls 

Answer: A 


Q32. When will the existing data for a new partition be visible to applications querying a range-partitioned table? 

A. After the ALTER TABLE ... ADD statement is executed. 

B. After the ALTER TABLE ... ATTACH statement is executed. 

C. After the ALTER TABLE ... ADD and SET INTEGRITY statements are executed. 

D. After the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed. 

Answer: D 


Q33. Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space? data objects have been moved from one storage group to another? 

A. MON_GET_TABLESPACE 

B. ADMIN_GET_STOGROUP_INFO 

C. ADMIN_GET_STORAGE_PATHS 

D. MON_GET_REBALANCE_STATUS 

Answer: D 


Q34. Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels? 

A. db2pd 

B. inspect 

C. db2dart 

D. db2mtrk 

Answer: A 


Q35. For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command? 

A. It will backup just the catalog partition. 

B. It will backup all partitions simultaneously. 

C. It will backup just the partition that the command is executed from. 

D. It will backup just the partitions that reside on the host that the command is executed from. 

Answer: C 


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


Q37. On which two operating systems can DB2 pureScale run? (Choose two.) 

A. AIX 

B. Linux 

C. HP-UX 

D. Solaris 

E. Windows 

Answer: A,B 


Q38. What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table? 

A. Call the ADMIN_MOVE_TABLE procedure. 

B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure. 

C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option. 

D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option. 

Answer: A 


Q39. What values can be assigned to the HADR_SYNCMODE configuration parameter? 

A. SYNC, NEARSYNC, ASYNC, and NOSYNC 

B. SYNC, NOSYNC, ASYNC, and SUPERASYNC 

C. SYNC, ASYNC, SEMISYNC, and SUPERASYNC 

D. SYNC, NEARSYNC, ASYNC, and SUPERASYNC 

Answer: D 


Q40. Which statement about Q Replication is correct? 

A. It uses continuous log shipping to replicate from the source database to the target database. 

B. It uses HADR message queues to transmit transactions between source and target databases. 

C. It uses WebSphere MQ message queues to transmit transactions between source and target databases. 

D. It uses replication control tables and changed data tables to replicate from the source database to the target database. 

Answer: C