Loading questions...
Updated
Which statement about NOT ENFORCED unique constraints is TRUE?
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?
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Which statement about label-based access control (LBAC) is TRUE?
A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the
SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?
Which of the following are valid Explain operators? (Choose two.)
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?
Create a free account to unlock all questions for this exam.
Log In / Sign UpWhich two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (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 days backup to take the longest time to complete?