DB2 10.1 DBA for Linux, UNIX, and Windows v6.0
Question 1
Which statement about updating index statistics with the RUNSTATS command is true?
- A. It requires a full index scan.
- B. It can be accomplished by sampling the index.
- C. It must be executed against all indexes for the table.
- D. It cannot be accomplished without scanning theassociated table.
Answer : B
Question 2
Which user-managed file system is required for DB2 pureScaledeployments?
- A. JFS2
- B. NTFS
- C. HPFS
- D. GPFS
Answer : D
Question 3
If the following command is executed:
Which statement is true?
- A. Rejected records will be inserted into the table SCHEMA2.E1
- B. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.
- C. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1
- D. If using aremote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.
Answer : A
Question 4
What can be used to provide input to the Design Advisor?
- A. An XML file.
- B. A query workload file.
- C. The database configuration file.
- D. The database manager configuration file.
Answer : B
Question 5
Given a system-period temporal table POLICY_INFO withits associated history table
HIST_POLICY_INFO, which statement is true?
- A. When querying with a time period specification, only the HIST_POLICY_INFO table is queried.
- B. When querying with no time period specification, only the HIST_POLICY_INFO table isqueried.
- C. When querying with a time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.
- D. When querying with no time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.
Answer : C
Question 6
What authority is required to create, alter and drop workload management objects?
- A. SYSADM
- B. SECADM
- C. WLMADM
- D. ACCESSCTRL
Answer : C
Question 7
What unit of measurement is used to represent the cumulative total cost of a node in a
Visual Explain access plan diagram?
- A. CPU cycles
- B. Elapsed time, in milliseconds
- C. Processing instructions performed
- D. Timerons
Answer : D
Question 8
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 theDISCOVER_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
Question 9
What is an informational constraint?
- A. A constraint that defines a relationship to a federated object.
- B. A constraint that is used by the optimizer but is not enforced.
- C. A constraint that provides Information to the RUNSTATS utility.
- D. A constraint that is created from information supplied to the design advisor.
Answer : B
Question 10
You have an High Availability and Disaster Recovery (HADR) environment set up and youwant to read from the standby database. What must you do?
- A. Assign the value ON to the DB2_HADR_ROS registry variable.
- B. Assign the value ON to the DB2_HADR_SNAP registry variable.
- C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
- D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
Answer : A
Question 11
Which command can be used to restore a corrupted database using only the recovery history file?
- A. RESTART DATABASE
- B. RECOVER DATABASE
- C. RESTORE DATABASE
- D. ROLLFORWARD DATABASE
Answer : B
Question 12
What is the correct procedure for recovering a dropped table when DROPPED TABLE
RECOVERY has been enabled and the database must remain online?
- A. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the dropped table.
- B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover thedropped table.
- C. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the dropped table.
- D. Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.
Answer : D
Question 13
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
Question 14
Which of the following table types is NOT supported by the load utility?
- A. A Temporal table
- B. A Range Partitioned table
- C. A Global Temporary table
- D. A MultidimensionalClustering table
Answer : C
Question 15
If the following statement is executed:
What indexes will be created for table TAB1?
- A. 1dimension-block index and 1 composite-block index
- B. 1 dimension-block index and 3 composite-block indexes
- C. 3 dimension-block indexes and 1 composite-block index
- D. 3 dimension-block indexes and 3 composite-block indexes
Answer : C