A2090-611 - Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows - Assessment
Go back to IBM
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?
It can be accomplished by sampling the index.
How can you remove all effects of compression from an index?
Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.
Which statement about triggers is FALSE?
A table-level trigger fires once for each table that is affected by a triggering event.
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?
When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.
What authority is required to create, alter and drop workload management objects?
Which statement is NOT true about a database restore operation?
A table space restore operation must be done offline.
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?
A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.
What does the FLUSH PACKAGE CACHE statement do?
It removes all dynamic SQL statements from the package cache.
Which statement about the REORGCHK command is true?
It automatically calls RUNSTATS by default.
Which SQL data type CANNOT be used to store XML indexed values?
Which statement is true about Insert Time Clustering (ITC) tables?
ITC tables are created with the CREATE TABLE command by specifying the ORGANIZE BY INSERT TIME clause.
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?
SET INTEGRITY FOR mytab IMMEDIATE CHECKED
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?
To recommend physical changes to objects in a database.
If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?
Self-tuning is not occurring because there are less than two memory consumers enabled.
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?
Immediately after asynchronous partition detach processing completes for this data partition.
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?
Drop and recreate the view with the WITH CHECK OPTION clause specified.
In IBM Data Studio, where can you schedule script-based jobs?
Which statement about primary keys is true?
A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.
Which authorities can be audited with the AUDIT statement?
SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.
Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)
The table contains a sufficient amount of data.
A table-level compression dictionary does not already exist for the table.
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?
Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.
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)?
By using the change history event monitor.
How is the time that an agent waits for log records to be flushed to disk calculated?
LOG_WRITE_TIME divided by TOTAL_COMMITS
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?
Reorganize the table to cluster its data according to that index.
What information can be obtained by analyzing EXPLAIN data?
Join methods, index use, and access type
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?
RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.
Which statement is correct for a user who holds SECADM authority?
A user who holds SECADM authority can grant and revoke all database level authorities and database object privileges.
Where are column mask definitions stored?
In the system catalog
Which statement describes a way to minimize the impact of a RUNSTATS operation?
Limit the number of pages and rows processed by using page-level or row-level table sampling.
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?
Assign the value ON to the DB2_HADR_ROS registry variable.
Which type of table space can be associated with only one storage group?
Automatic storage space (AS)
Which statement regarding compression for temporary tables is true?
Temporary tables can only be compressed using classic row compression.
Which statement about the db2pd tool is true?
It may retrieve data that is not completely accurate.
Which statement is true regarding client-server database connectivity?
A remote connection is established between a DB2 client in a different location from the database server.