Cause all that matters here is passing the IBM C2090-611 exam. Cause all that you need is a high score of C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows exam. The only one thing you need to do is downloading Pass4sure C2090-611 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 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
Q21. What is the purpose of the Design Advisor?
A. To recommend physical changes to objects in a database.
B. To recommend database configuration parameter changes.
C. To generate profiles for autonomic activity within the database.
D. To generate query definitions required to create usage reports.
Answer: A
Q22. A table named SALES was created as follows:
If management wants to use Label-Based Access Control (LBAC) to protect individual columns 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 SECURED WITH clause to every column in 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: D
Q23. What are two types of security label components that can be used with Label-Based Access
Control (LBAC)? (Choose two).
A. Set
B. Tree
C. Group
D. Range
E. Hierarchy
Answer: A,B
Q24. If the following statements are executed in the order shown:
Which statement is true?
A. Insert, update, and delete operations can be performed against table TAB2.
B. Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.
C. Insert, update, and delete operations performed against table TAB1 are automatically cascaded to table TAB2.
D. The REFRESH TABLE statement must be executed before insert, update, and delete operations performed against table TAB1 will be seen intable TAB2.
Answer: C
Q25. Which statement regarding SECADM authority is true?
A. The instance owner has SECADM authority by default.
B. PUBLIC cannot receive SECADM authority, either directly or indirectly.
C. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.
D. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.
Answer: B
Q26. Which statement is correct when describing trusted contexts?
A. A trusted context defines a trust relationship for a connection between the database and an external entity.
B. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.
C. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.
D. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.
Answer: A
Q27. The following commands are executed against a database named MY_DB, which has been configured to use archival logging:
Which statement is true?
A. Upon completion of the Load, the table T1 is placed into "Backup Pending" state.
B. Upon completion of the Load, a backup image of table T1 is automatically generated.
C. After a Restore and Rollforward operation, table T1 would be marked unavailable and can only be dropped.
D. After a Restore and Rollforward operation, the loaded data is stored into a copy-image file and table T1 is fully available.
Answer: C
Q28. Which tool should be used to collect data during a potential hang without stopping the database manager?
A. db2ls
B. db2dart
C. db2fodc
D. db2cklog
Answer: C
Q29. Which statement about DB2 aggregate registry variables is true?
A. An aggregate registry variable that is explicitly set by an application cannot be overwritten.
B. An aggregate registry variable overrides any corresponding explicitly set registry variable.
C. A registry variable that is explicitly set by an application can only be overwritten by aggregate registry variable.
D. A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.
Answer: D
Q30. 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