Oracle
1Z0-064 · Question #72
1Z0-064 Question #72: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.
Question
Examine the parameter values configured in your database: sga_max_size = 480M sga_target = 480M pga_aggregate_target = 160M The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333. You execute the commands: SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(
SH',CUSTOMERS'); PL/SQL procedure successfully completed. SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID); Index created. You then perform several INSERT, UPDATE, and DELETE operations, significantly altering the data in the table. View the Exhibit to examine the query and its execution plan. Which three options would improve the performance of the query? (Choose three.)Exhibit
Options
- Acreating a bitmap index on the COUNTRY_ID column
- Bregathering statistics on the CUSTOMERS table
- Ccreating a histogram on the COUNTRY_ID column
- Dincreasing the size of the PGA
- Ecreating an SQL profile
- Fcreating a KEEP cache
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.