Exambible offers free demo for C2090-611 exam. "DB2 10.1 DBA for Linux, UNIX, and Windows", also known as C2090-611 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-611 exam, will help you answer those questions. The C2090-611 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-611 exams and revised by experts!
♥♥ 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
Q31. Which statement about the db2pd tool is true?
A. It may retrieve data that is not completely accurate.
B. It collects information from the log buffer and active log files.
C. It ensures that information is not retrieved on changing data.
D. It collects information from the snapshot monitor and a predefined set of event monitors.
Answer: A
Q32. What authority is required to create, alter and drop workload management objects?
A. SYSADM
B. SECADM
C. WLMADM
D. ACCESSCTRL
Answer: C
Q33. Given the following statement:
How many constraints are present in the DEPARTMENT table?
A. 1
B. 2
C. 3
D. 4
Answer: D
Q34. If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?
A. Crash recovery
B. Version recovery
C. Disaster recovery
D. Roll-forward recovery
Answer: A
Q35. 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
Q36. Where are column mask definitions stored?
A. In the table definition
B. In the system catalog
C. In the table space metadata
D. In the database configuration file
Answer: B
Q37. If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?
A. Crash recovery
B. Version recovery
C. Disaster recovery
D. Roll-forward recovery
Answer: A
Q38. A table named SALES was created as follows:
If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the
SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?
A. Associate the SEC_POLICY security policy with the SALES table.
B. Add a column with the DB2SECURITYLABEL data type to the SALES table.
C. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.
D. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.
Answer: C
Q39. If you are running DB2 in clustered environment, what utility should you use to get the status of cluster?
A. db2istat
B. db2clust
C. db2haicu
D. db2hastat
Answer: C
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