Which three pieces of information would you check to confirm that the statistics have been collected?

In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected? (Choose three.)

In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected? (Choose three.)

A.
last analyzed date

B.
average row size

C.
number of extents present in the table

D.
size of table in bytes

E.
size of table in database blocks

F.
number of free blocks in the free list



Leave a Reply 0

Your email address will not be published. Required fields are marked *