C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam
Go back to IBM
Which command will be executed successfully on every database partition if db2_all is used?
Where is the HADR_TARGET_LIST configuration parameter set?
On all participating databases.
Which statement about dropped table recovery is correct?
For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.
Which operation can be performed by executing an ALTER STOGROUP statement?
Make an existing storage group the default storage group.
Which statement about SMS table spaces is correct?
SMS table spaces are recommended when you have small tables that are not likely to grow quickly.
What is the preferred method for reclaiming unused storage in a DMS table space?
Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?
One index that serves as both the dimension block index and the composite block index.
Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?
Which statement about Range Clustered Tables (RCT) is correct?
When defining a range of key values for an RCT, a minimum value is optional.
The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
CREATE INDEX sales_idx ON sales (region, sales_person)
Which tool provides the simplest method for monitoring buffer pool hit ratios?
The BP_HITRATIO administrative view.
A DBA wants to create a table named SALES that has the following characteristics: Which clause must be used with the CREATE TABLE statement to define this table?
PARTITION BY RANGE
A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2 10.1. When will a default storage group be defined for this database?
The first time the CREATE STOGROUP statement is executed.
On which two operating systems can DB2 pureScale run? (Choose two.)
An auditor has requested that all activities performed by those with SYSADM or DBADM authority be tracked. How can this be done with the db2audit tool?
By creating an AUDIT POLICY and associating it with SYSADM and DBADM authority.
In which situation would you NOT use a redirected restore?
To restore a backup image from one operating system to another.
Which Range-Clustered Tables (RCT) statement is correct?
Reverse scans on RCTs are not supported.
What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?
For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?
It will backup just the partition that the command is executed from.
What statement regarding Asynchronous index cleanup (AIC) is correct?
AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
What is the FAILARCHPATH database configuration parameter used for?
To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.
What must be done to convert a populated base table to a multidimensional clustering (MDC) table?
Export the data, create an MDC table, and then import or load the data into the MDC table.
The following statement was used to create a table space named USER_TMP in a non-partitioned database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (?mnt/fsystem4? ?mnt/fsystem5? Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?
A different buffer pool can be associated with it.
What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)
Table space available space
Table space read and write activity
Which statement about compression dictionaries is FALSE?
Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.
Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?
Columns with high cardinalities
In what situation should you use a redirected restore operation?
You want to restore your table space containers into a different physical location.
Which statement about DB2 Merge Backup is FALSE?
It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?
Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.
What must you do before an online table space backup operation can be performed?
Create a full database backup image.
An auxiliary HADR standby database must use which HADR sync mode?
What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?
Call the ADMIN_MOVE_TABLE procedure.
What will occur when a database administrator adds a new automatic storage path to an existing storage group?
Existing table spaces will not consume storage on the new path.
Which is NOT a valid method for prefetching data?
Which statement about Insert-Time-Clustered (ITC) is correct?
Block indexes cannot be created for ITC tables.
Which table configuration CANNOT utilize multi-temperature storage?
Multiple tables containing the same data at different ages placed into the same table space.
To configure instance-level auditing with db2audit, which authority is required?
A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
ORGANIZE BY INSERT TIME
What contributes to the efficient use of block-based buffer pools?
The table space extent size is equal to the block size specified for the buffer pool.
What values can be assigned to the HADR_SYNCMODE configuration parameter?
SYNC, NEARSYNC, ASYNC, and SUPERASYNC
What is the recommended method for removing old backup images and log files for a DB2 10.1 database?
Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.
A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?
Drop the nickname to the table.Create the new data type mapping.Recreate the nickname to the table.
Which statement about Range-Clustered Tables (RCTs) is correct?
Space is pre-allocated and reserved for use by the table even when records do not yet exist.
Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space? data objects have been moved from one storage group to another?
Which statement about partitioned indexes is FALSE?
When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in thecorresponding partition index.
You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?
The database recovery history file
What can be done to prevent applications from failing when DB2 cannot create a new log file?
Set BLK_LOG_DSK_FUL to YES
A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?
3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for alldatabases.
Which statement about Q Replication is correct?
It uses WebSphere MQ message queues to transmit transactions between source and target databases.
What is a benefit of multi-temperature data storage?
It helps reduce storage costs for infrequently accessed data.