we provide Downloadable IBM C2090-611 practice exam which are the best for clearing C2090-611 test, and to get certified by IBM DB2 10.1 DBA for Linux, UNIX, and Windows. The C2090-611 Questions & Answers covers all the knowledge points of the real C2090-611 exam. Crack your IBM C2090-611 Exam with latest dumps, guaranteed!
♥♥ 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
Q11. What are two purposes of the SET INTEGRITY statement? (Choose two.)
A. To bring a table out of "Set Integrity Pending" state by performing the required integrity processing on the table.
B. To bring a table out of "Set Integrity Pending" state by performing only check constraint processing on the table.
C. To bring a table out of "Set Integrity Pending" state without performing the required integrity processing on the table.
D. To bring a table out of "Set Integrity Pending" state by performing only referential integrity constraint processing on the table.
E. To bring a table out of "Set Integrity Pending" state by performing only referential integrity and check constraint processing on the table.
Answer: A,C
Q12. What authorization is needed to execute the CREATE MASK statement?
A. SECADM
B. SQLADM
C. SYSADM
D. SYSCTRL
Answer: A
Q13. 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
Q14. Which authority is required to revoke SECADM authority?
A. DBADM
B. SECADM
C. SYSADM
D. SQLADM
Answer: B
Q15. Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption in table space TBSP_1?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE TABLESPACE
D. ROLLFORWARD DATABASE
Answer: B
Q16. Which command will enable automatic reorg on a database?
A. UPDATE DB CFG USING AUTO_REORG ON
B. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON
C. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON
D. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON
Answer: D
Q17. Which is a valid statement about the Row and Column Access Control (RCAC) feature?
A. Users with SECADM authority are exempt from RCAC rules.
B. The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality.
C. RCAC is a more powerful security mechanism than Label Based Access Control (LBAC).
D. When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.
Answer: D
Q18. The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows:
What commands must be run to enable real-time statistics collection on the SAMPLE database?
A. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;
UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
B. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;
UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;
UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
C. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;
UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;
UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;
D. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;
UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;
Answer: B
Q19. 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
Q20. Table TAB_A resides within table space TBSP_1.
Which statement is correct?
A. TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.
B. A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read thedata that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.
C. The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will beappended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.
D. The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also bebuilt using the INCREMENTAL indexing mode, the concurrency of table TAB_A will be maximized for any applications that wish to access thetable.
Answer: A