A2090-611 - Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows - Assessment

Go back to IBM

Example Questions

What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram? Which user-managed file system is required for DB2 pureScale deployments? Which table space is NOT created by default when the CREATE DATABASE command is executed? Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file? Which statement about updating index statistics with the RUNSTATS command is true? How can you remove all effects of compression from an index? Which statement about triggers is FALSE? If you are running DB2 in clustered environment, what utility should you use to get the status of cluster? Which is a valid statement about the Row and Column Access Control (RCAC) feature? What authority is required to create, alter and drop workload management objects? Which statement is NOT true about a database restore operation? What authority is required to grant a user ACCESSCTRL authority? What authorization is needed to execute the CREATE MASK statement? Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database? 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 should be used to recover the database and repair the corruption in table space TBSP_1? Which statement about DB2 aggregate registry variables is true? What does the FLUSH PACKAGE CACHE statement do? Which statement about the REORGCHK command is true? Which SQL data type CANNOT be used to store XML indexed values? Which statement is true about Insert Time Clustering (ITC) tables? Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database? Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data? Which authority is required to revoke SECADM authority? Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)? What is the purpose of the Design Advisor? If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true? When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table? You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do? In IBM Data Studio, where can you schedule script-based jobs? Which statement about primary keys is true? Which authorities can be audited with the AUDIT statement? Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.) Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas? 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? Which command can be used to restore a corrupted database using only the recovery history file? How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)? How is the time that an agent waits for log records to be flushed to disk calculated? By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table? What information can be obtained by analyzing EXPLAIN data? Which tool should be used to give you lock wait information from the DB2 memory sets? If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen? Which statement is correct for a user who holds SECADM authority? Where are column mask definitions stored? Which statement describes a way to minimize the impact of a RUNSTATS operation? Which tool should be used to collect data during a potential hang without stopping the database manager? You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do? Which type of table space can be associated with only one storage group? Which statement regarding compression for temporary tables is true? Which statement about the db2pd tool is true? Which statement is true regarding client-server database connectivity?