C2090-611 - DB2 10.1 DBA for Linux, UNIX, and Windows

Go back to IBM

Example Questions

What is the purpose of the Design Advisor? Which of the following table types is NOT supported by the load utility? What type of Label-Based Access Control (LBAC) security label component is used to define a scale in which the first element listed represents the highest level of trust a person can have and the last element listed represents the lowest level of trust a person can have? Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles? Which command will define the alternate diagnostic data directory path as /db2data/db2dump2? Given a system-period temporal table POLICY_INFO with its associated history table HIST_POLICY_INFO, which statement is true? In IBM Data Studio, where can you schedule script-based jobs? 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? Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database? What can be used to provide input to the Design Advisor? Which statement about the REORGCHK command is true? Which statement is correct for a user who holds SECADM authority? Which statement about primary keys is true? Which is the suggested way to restore a database with a subset of its original table spaces? What authorization is needed to execute the CREATE MASK statement? What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online? What is an informational constraint? What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two). What authority is required to grant a user ACCESSCTRL authority? Which statement is true regarding client-server database connectivity? What is the MAX_LOG database configuration parameter used for? 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? What does the FLUSH PACKAGE CACHE statement do? Which statement regarding snapshot administrative views and snapshot monitor table functions is true? Which action can a DBA take to retrieve bufferpool metrics information? 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? Which statement about the db2pd tool is true? Which statement regarding compression for temporary tables is true? 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? Which authority is required to revoke SECADM authority? Where are column mask definitions stored? If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen? How can you remove all effects of compression from an index? If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true? Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and a DB2 server? Which SQL data type CANNOT be used to store XML indexed values? Which command is used to export connectivity configuration information from a file known as a configuration profile? What are two purposes of the SET INTEGRITY statement? (Choose two.) Which user-managed file system is required for DB2 pureScale deployments?