What do you use to obtain this information?
You want to estimate the potential index compression savings for existing
indexes on a table
What do you use to obtain this information?
When will all of the rows in the table be compressed?
You have a new table created with COMPRESS YES and a delimited ASCII file.
You use the LOAD utility to load the data from the ASCII file into the table.
When will all of the rows in the table be compressed?
What are three reasons why this is happening?
You are unable to configure a data source using DB2 Discovery.
What are three reasons why this is happening? (Choose three.)
What are two key requirements?
You want to federate communication between two databases
What are two key requirements? (Choose two.)
Which driver(s) must be installed before SQU and JDBC applications can connect to DB2 databases?
Which driver(s) must be installed before SQU and JDBC applications can
connect to DB2 databases?
Which list of automatic maintenance parameters can have a policy defined to specify their automatic behavior?
Which list of automatic maintenance parameters can have a policy defined
to specify their automatic behavior?
Which configuration parameters will allow your Saturday job to run when the scheduler is restarted?
You have a job scheduled to run every Saturday; the scheduler is turned
off on Friday and then restarted on Monday. The job scheduled for Saturday
is now a job that is scheduled in the past.
Which configuration parameters will allow your Saturday job to run when the
scheduler is restarted?
What are the maximum amount of system resources that the backup utility can use?
You have a UTIL_IMPACT_LIM of 50 and a UTIL_!MPACT_PRIORITY of 60 for the
backup utility
What are the maximum amount of system resources that the backup utility can
use?
Which command is used to configure the administrative task scheduler to execute tasks?
Which command is used to configure the administrative task scheduler to
execute tasks?
Which three statements will cause the memory tuner to actively tune memory within the database?
The SELF_TUNING_MEM database configuration (db cfg) parameter is set to
ON. Which three statements will cause the memory tuner to actively tune memory within the
database? (Choose three.)