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 query performance?
Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?
What is the FAILARCHPATH database configuration parameter used for?
An auxiliary HADR standby database must use which HADR sync mode?
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
