Which two activities indicate the need for a data warehouse?
Which two activities indicate the need for a data warehouse? (Choose two.)
What is the primary function of an Online Transaction Processing (OLTP) workload?
What is the primary function of an Online Transaction Processing (OLTP) workload?
Which isolation level offers the greatest protection of data but provides the least amount of concurrency?
Which isolation level offers the greatest protection of data but provides the least amount of
concurrency?
where can you schedule script-based jobs?
In IBM Data Studio, where can you schedule script-based jobs?
What factor influences lock escalation?
What factor influences lock escalation?
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked d
Which type of lock allows the lock owner and all concurrent applications to read, but not
update, the locked data?
what isolation level must application APP_B use?
Application APP_A is performing updates to table TAB1 using the cursor stability (CS)
isolation level. If application APP_B wants to retrieve all rows from table TAB1 without
waiting for application APP_A to finish making updates, what isolation level must application
APP_B use?
What commands must be run to enable real-time statistics collection on the SAMPLE database?
The values of the automatic maintenance database configuration parameters for a database
named SAMPLE are as follows: What commands must be run to enable real-time statistics
collection on the SAMPLE database?
Which statement will prevent concurrent application processes from performing anything other than read-only op
Which statement will prevent concurrent application processes from performing anything
other than read-only operations against a table named TAB1?
When is an INTENT EXCLUSIVE (IX) lock required?
When is an INTENT EXCLUSIVE (IX) lock required?