000-611 - DB2 10.1 DBA for Linux, UNIX, and Windows
Go back to IBM
What authorization is needed to execute the CREATE MASK statement?
You have just converted an existing database to an automatic storage database. What can you use to move data from an existing DMS table space to an automatic storage table space, while the data remains online and available for access?
The ADMIN_MOVE_TABLE procedure
Which statement describes adaptive row compression?
Adaptive compression incorporates both classic table-level row compression and page-by-page based row compression.
Which statement about adaptive compression is true?
When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.
What is an informational constraint?
A constraint that is used by the optimizer but is not enforced.
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 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 statement about updating index statistics with the RUNSTATS command is true?
It can be accomplished by sampling the index.
Which statement about BEFORE triggers is FALSE?
A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.
Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and a DB2 server?
Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTER TABLESPACE my_ts REBALANCE;
What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?
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.
Which of the following table types is NOT supported by the load utility?
A Global Temporary table
Which statement about the ADMIN_MOVE_TABLE procedure is true?
If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.
Which authority is required to revoke SECADM authority?
Which statement about range-clustered tables is true?
Range-clustered tables can be used with multiple-column keys.
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 statement is correct when describing trusted contexts?
A trusted context defines a trust relationship for a connection between the database and an external entity.
What does the FLUSH PACKAGE CACHE statement do?
It removes all dynamic SQL statements from the package cache.
In IBM Data Studio, where can you schedule script-based jobs?
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.
Where are column mask definitions stored?
In the system catalog
Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?
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 statement about Binary XML is FALSE?
Only textual XML data format is supported by Binary XML.
Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)
Which authorities can be audited with the AUDIT statement?
SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.
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?
How is the time that an agent waits for log records to be flushed to disk calculated?
LOG_WRITE_TIME divided by TOTAL_COMMITS
What can be used to provide input to the Design Advisor?
A query workload file.
Which statement regarding SECADM authority is true?
PUBLIC cannot receive SECADM authority, either directly or indirectly.
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.
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.
What is the MAX_LOG database configuration parameter used for?
To limit the percentage of primary log space a running transaction can consume.
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 are two types of DB2 Discovery requests that a client can make? (Choose two.)
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 insert time clustering tables (ITC) is true?
Rows of an ITC table are clustered by the time they are inserted into the table.
Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?
UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2
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 statement is true regarding the workload management dispatcher?
The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.
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.
Which command can be used to restore a corrupted database using only the recovery history file?