High value of C2090-611 simulations materials and answers for IBM certification for examinee, 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 Apr C2090-611 Study Guide Questions:
Q11. How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)?
A. By using the change history event monitor.
B. By using the DB2 problem determination tool.
C. By examining the contents of the system catalog.
D. By examining the DB2 administration notification log file.
Answer: A
Q12. Which statement about triggers is FALSE?
A. A statement-level trigger fires only once for each SQL statement.
B. A trigger's code block can be executed either before or after a triggering event.
C. A row-level trigger fires once for each row that is affected by a triggering event.
D. A table-level trigger fires once for each table that is affected by a triggering event.
Answer: D
Q13. If an MQT named Q1_SALES was created as follows:
Which statement will execute successfully?
A. DELETE FROM q1_sales
B. REFRESH TABLE q1_sales
C. INSERT INTO q1_sales VALUES(80.2)
D. ALTER TABLE q1_sales REFRESH IMMEDIATE
Answer: B
Refresh C2090-611 actual exam:
Q14. 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
Q15. 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
Q16. A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC
STORAGE NO What is the recommended way to convert the database MYDB to an automatic
storage database?
A. Use the ALTER DATABASE statement to add storage paths to the database.
B. Use the CREATE STOGROUP statement to define a new storage group in the database and to assign storage paths to the new storage group.
C. Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC
STORAGE configuration parameter for the database toYES.
D. Use the DROP DATABASE command to drop the database; then, recreate the database by
executing a CREATE DATABASE commandstatement that does not contain the AUTOMATIC
STORAGE NO option.
Answer: B
Free C2090-611 secret:
Q17. The following statement is run:
Which statement about the ACCT_BALANCE column is true?
A. Values stored in the ACCT_BALANCE column are visible to all users.
B. Values stored in the ACCT_BALANCE column are not visible to any user.
C. Values stored in the ACCT_BALANCE column are only visible to users with the ACCOUNTING role.
D. Values stored in the ACCT_BALANCE column are not visible to users with the ACCOUNTING role.
Answer: A
Q18. Which authorities can be audited with the AUDIT statement?
A. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.
B. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.
C. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.
D. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and
SECADM cannot.
Answer: C
Q19. What authorization is needed to use the AUDIT statement to create an audit policy?
A. DBADM
B. SYSADM
C. SECADM
D. SYSMAINT
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