A2090-614 Exam Questions

Which operation can be performed by executing an ALTER STOGROUP statement?

Which statement about SMS table spaces is correct?

Which type of storage is utilized in the implementation of an effective and flexible multi- temperature database?

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 dete...

Which statement about DB2 Merge Backup is FALSE?

What can be done to prevent applications from failing when DB2 cannot create a new log file?

What values can be assigned to the HADR_SYNCMODE configuration parameter?

Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

What is the default user workload class that is created for each database table?

Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to per...

Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?

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 wi...

In what situation should you use a redirected restore operation?

In which situation would you NOT use a redirected restore?

After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?

If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?

Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?

Given the following database design: A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which act...

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

Which statement about the initiation of parallel I/O is correct?

The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log): MESSAGE : ADM5502W The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X"...

Consider the following statement: Which indexes should be created for optimal query performance?

What will occur when a database administrator adds a new automatic storage path to an existing storage group?

Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?

Which statement about value compression is correct?

What advantage do block-based buffer pools offer compared to regular buffer pools?

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...

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 cluste...

What must be done to convert a populated base table to a multidimensional clustering (MDC) table?

Which command(s) should be used to drop database partition 10 from a database named MYDB?

If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?

Given the following output: Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?

What contributes to the efficient use of block-based buffer pools?

What is a benefit of multi-temperature data storage?

A storage group named HOT_SG was created as follows: What does the DATA TAG 1 clause do?

Which statement about partitioned indexes is FALSE?

What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

A DBA wants to create a table named SALES that has the following characteristics: -Data for the first half of the year will reside in table space TBSP1; the index for this data wil...

Which Range-Clustered Tables (RCT) statement is correct?

A table named SALES was created as follows: Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data...

In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?

What is the recommended method for removing old backup images and log files for a DB2 10.1 database?

Which diagnostic tool can be used to collect metrics on individual SQL statement executions?

What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)

Where is the HADR_TARGET_LIST configuration parameter set?

Which statement about dropped table recovery is correct?

Which three table features can be used concurrently in the same table? (Choose three.)

Which statement is true about unique constraints?