Oracle Exam 1Z0-064 Topic 9 Question 15 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 15
Topic #: 9

Examine the parameters set for your database instance:

To investigate the slow response time of queries on the TRANS table, you gather table and execute the query:

The table is stored in a tablespace with Automatic Segment Space Management (ASSM), and some rows of the TRANS table are migrated and chained.

Which two actions would you recommend to improve query response time?

AReorganize the TRANS table online by using the DBMS_REDEFINITION package.

BCreate a bigger non-standard blocksize tablespace and move the TRANS table to that tablespace.

CMove the TRANS table to a tablespace with manual segment space management with a lower value set for the PCTUSED attribute.

DMove the TRANS table to a tablespace with manual segment space management with a higher value set for the PCTFREE attribute.

Show Suggested Answer

Suggested Answer: A, D

by Kallie at May 09, 2022, 03:10 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!