Tested of C2090-611 real exam materials and bootcamp 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 May C2090-611 Study Guide Questions:
Q21. Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?
A. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;
B. ALTER TABLEPACE my_ts MANAGED BY DATABASE;
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;
C. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2'
ALTER TABLESPACE my_ts REBALANCE;
D. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2'
ALTER TABLESPACE my_ts REBALANCE;
Answer: A
Q22. Which command is used to import connectivity configuration information from a file known as a configuration profile?
A. db2ca
B. db2cfexp
C. db2cfimp
D. db2cfgimp
Answer: C
Q23. An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?
A. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.
B. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.
C. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.
D. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.
Answer: D
Up to the immediate present C2090-611 testing engine:
Q24. 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
Q25. Which table space is NOT created by default when the CREATE DATABASE command is executed?
A. USERSPACE1
B. TEMPSPACE1
C. SYSCATSPACE
D. SYSTOOLSSPACE
Answer: D
Q26. Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?
A. DBADM
B. SYSADM
C. SQLADM
D. SECADM
Answer: D
Verified C2090-611 practice exam:
Q27. 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
Q28. 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
Q29. Which statement is correct when describing Range Clustered Tables (RCT) as compared to
regular base tables that use at least one index?
A. RCTs require less logging, less buffer pool space, and less maintenance.
B. RCTs require more logging, less buffer pool space, and more maintenance.
C. RCTs require less logging, more buffer pool space, and less maintenance.
D. RCTs require more logging, more buffer pool space, and less maintenance.
Answer: A
Q30. A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?
A. Set the DISCOVER_DB database manager configuration parameter for the DEV instance to DISABLE.
B. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.
C. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.
D. Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.
Answer: D