You received complaints from users about slow response time in some parts of the application. On investigation, you find that this happens whenever the application runs any query against the PROD_DET table that contains detailed information about all the products. You gathered the table statistics and executed the following statements to find more information about this table: SQL SELECT chain_cnt, 2 round(chain_cnt/num_rows*100,2) pct_chained, 3 avg_row_len, pct_free , pct_used 4 FROM user_tables 5 WHERE table_name = 'PROD_DET'; CHAIN_CNT PCT_CHAINED AVG_ROW_LEN PCT_FREE PCT_USED ---------- ----------- ----------- ---------- ---------- 4789 100 3691 10 40 Which methods can you use to improve the performance? (Choose all that apply.)

Question

You received complaints from users about slow response time in some parts of the application. On investigation, you find that this happens whenever the application runs any query against the PROD_DET table that contains detailed information about all the products. You gathered the table statistics and executed the following statements to find more information about this table: SQL> SELECT chain_cnt, 2 round(chain_cnt/num_rows*100,2) pct_chained, 3 avg_row_len, pct_free , pct_used 4 FROM user_tables 5 WHERE table_name = 'PROD_DET'; CHAIN_CNT PCT_CHAINED AVG_ROW_LEN PCT_FREE PCT_USED ---------- ----------- ----------- ---------- ---------- 4789 100 3691 10 40 Which methods can you use to improve the performance? (Choose all that apply.)

Accepted Answer

A. online table redefinition B. export and import the table D. move the table using the ALTER TABLE command

Answer

C. decrease the PCTFREE value

1Z0-054 Question #110: Real Exam Question with Answer & Explanation

Question

Options

Community Discussion