Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
Which phase of the LOAD utility is unique to loading column organized tables?
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
What levels of authority are needed to create a storage group? (Choose two.)
A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes).
Sunday – Delta
Monday – Incremental
Tuesday – Delta
Wednesday – Delta
Thursday – Incremental
Friday – Delta
Saturday – Full
Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest time to complete?
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?
An HADR environment has two standby databases – one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?
What is an advantage of using range partitioned tables?