IBM
C2090-619 · Question #66
C2090-619 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-619 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable = ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name = ?uto_crsd? UPDATE ph_threshold SET value = ?WHERE name = UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name = ?UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name = UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name = ?UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?
Options
- ACompress all tables with less than 5000 rows.
- BCompress and defragment tables with more than 5000 uncompressed rows.
- CCompress, repack and shrink tables with more than 5000 uncompressed rows.
- DDo not compress, repack, shrink and defragment any table with more than 5000 rows.
Unlock C2090-619 to see the answer
You've previewed enough free C2090-619 questions. Unlock C2090-619 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.