An analytics team uses a multibillion row table that is relevant to a great number of queries with different filters and joins. The Administrator needs to identify an effective strategy to collect statistics on this table.Which statistics should be collected?
A customer has to use Data Mover with legacy tools to transfer data from the production system to the disaster recovery (DR) system. Both systems are on-prem, but located in different geographies.Where should the Data Mover Server be deployed to provide optimum data transfer?
Which option in READ_NOS will reduce the number of objects scanned by queries?
An update of a very large table was in progress when the system experienced an unplanned restart. After restarting, the system is available, but Recovery Manager shows it may be many hours before a large table is available for use. The Administrator needs to make the table available sooner.Which option should be used to achieve this goal?
A business' operating periods are event-driven, and the batch window begins and ends at various times of the evening. The Administrator needs to configure TASM to dynamically trigger the reporting planned environment using an API call issued when the batch window ends.Which type of event can the Administrator use to meet this requirement?
There is corruption in a table in the DBC database.Which action should the Administrator take to restore the table?