Practical of C2090-611 exam topics materials and paper for IBM certification for IT learners, Real Success Guaranteed with Updated C2090-611 pdf dumps vce Materials. 100% PASS DB2 10.1 DBA for Linux, UNIX, and Windows exam Today!
2021 May C2090-611 Study Guide Questions:
Q31. If the following statement is executed:
What indexes will be created for table TAB1?
A. 1 dimension-block index and 1 composite-block index
B. 1 dimension-block index and 3 composite-block indexes
C. 3 dimension-block indexes and 1 composite-block index
D. 3 dimension-block indexes and 3 composite-block indexes
Answer: C
Q32. Which statement about primary keys is true?
A. A table can have multiple primary keys.
B. A primary key accepts one, and only one, NULL value.
C. A unique index, with matching columns of the primary key, must be created before a primary key can be created.
D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.
Answer: D
Q33. Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?
A. XSLPARSE
B. XSLELEMENT
C. XSLCONVERT
D. XSLTRANSFORM
Answer: D
Update C2090-611 free exam:
Q34. What information can be obtained by analyzing EXPLAIN data?
A. Access type, index use, and work load
B. Index use, work load, and join methods
C. Work load, access type, and join methods
D. Join methods, index use, and access type
Answer: D
Q35. Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?
A. SYNC (synchronous)
B. ASYNC (asynchronous)
C. NEARSYNC (near synchronous)
D. SUPERASYNC (super asynchronous)
Answer: D
Q36. Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and a DB2 server?
A. String
B. Binary
C. Delimited ASCII
D. Non-delimited ASCII
Answer: B
High quality C2090-611 braindump:
Q37. Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database?
A. DB2_INDEX_DEFAULT
B. DB2_EXTENDED_OPTIMIZATION
C. DB2_INDEX_PCTFREE_DEFAULT
D. DB2_ENABLE_AUTOCONFIG_DEFAULT
Answer: C
Q38. You have just converted an existing database to an automatic storage database. What can you use to move data from an existing DMS table space to an automatic storage table space, while the data remains online and available for access?
A. The db2move command
B. The db2relocatedb command
C. The ADMIN_MOVE_TABLE procedure
D. The ADMIN_MOVE_TABLE_UTIL procedure
Answer: C
Q39. 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
Q40. Which statement regarding compression for temporary tables is true?
A. Temporary tables can only be compressed using adaptive compression.
B. Temporary tables can only be compressed using classic row compression.
C. Compression for temporary tables can be dynamically enabled and disabled.
D. The DB2 optimizer automatically decides to use classic row compression or adaptive compression for temporary tables.
Answer: B