C2090-611 - DB2 10.1 DBA for Linux, UNIX, and Windows
Go back to IBM
What is the purpose of the Design Advisor?
To recommend physical changes to objects in a database.
Which of the following table types is NOT supported by the load utility?
A Global Temporary table
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?
UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2
Given a system-period temporal table POLICY_INFO with its associated history table HIST_POLICY_INFO, which statement is true?
When querying with a time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.
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?
A query workload file.
Which statement about the REORGCHK command is true?
It automatically calls RUNSTATS by default.
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.
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 is the suggested way to restore a database with a subset of its original table spaces?
Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.
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?
Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.
What is an informational constraint?
A constraint that is used by the optimizer but is not enforced.
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?
A remote connection is established between a DB2 client in a different location from the database server.
What is the MAX_LOG database configuration parameter used for?
To limit the percentage of primary log space a running transaction can consume.
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.
What does the FLUSH PACKAGE CACHE statement do?
It removes all dynamic SQL statements from the package cache.
Which statement regarding snapshot administrative views and snapshot monitor table functions is true?
Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.
Which action can a DBA take to retrieve bufferpool metrics information?
Ensure the MON_OBJ_METRICS configuration parameter is enabled and query the MON_GET_BUFFERPOOL table function.
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?
Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.
Which statement about the db2pd tool is true?
It may retrieve data that is not completely accurate.
Which statement regarding compression for temporary tables is true?
Temporary tables can only be compressed using classic row compression.
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?
In the system catalog
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.
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.
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.
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.)
To bring a table out of "Set Integrity Pending" state by performing the required integrity processing on the table.
To bring a table out of "Set Integrity Pending" state without performing the required integrity processing on the table.
Which user-managed file system is required for DB2 pureScale deployments?