What action would the DBA have taken to resolve the performance problem?

Users of HR schema complain about slower-than-normal performance. On investigation the DBA
found that maintenance was recently performed on some of the tables. The DBA traced the query
that takes longer than normal to execute.
View the Exhibit exhibit_before.
After the DBA resolves the problem, the query performs normally.
View the Exhibit exhibit_after.
What action would the DBA have taken to resolve the performance problem?

Users of HR schema complain about slower-than-normal performance. On investigation the DBA
found that maintenance was recently performed on some of the tables. The DBA traced the query
that takes longer than normal to execute.
View the Exhibit exhibit_before.
After the DBA resolves the problem, the query performs normally.
View the Exhibit exhibit_after.
What action would the DBA have taken to resolve the performance problem?

A.
analyzed the EMPLOYEES table to collect the current statistics

B.
moved the EMPLOYEES table in to a locally managed tablespace

C.
reorganized the associated indexes for the EMPLOYEES table that were in an unusable state

D.
moved the EMPLOYEES table to another location in the same tablespace

E.
moved the indexes associated with the EMPLOYEES table to the same tablespace where the
EMPLOYEES table exists



Leave a Reply 0

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