C2090-619 · Question #66
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…
The correct answer is C. Compress, repack and shrink tables with more than 5000 uncompressed rows. See the full explanation below for the reasoning.
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.
How the community answered
(45 responses)- A9% (4)
- B2% (1)
- C84% (38)
- D4% (2)
Community Discussion
No community discussion yet for this question.