exam questions

Exam 1z0-064 All Questions

View all questions & answers for the 1z0-064 exam

Exam 1z0-064 topic 1 question 23 discussion

Actual exam question from Oracle's 1z0-064
Question #: 23
Topic #: 1
[All 1z0-064 Questions]

Your database supports an OLTP system.
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 a series of INSERT, UPDATE, and DELETE operations on the table.
View the Exhibit to examine the query and its execution plan.

Which two options can improve the performance of the query without significantly slowing down the DML operations? (Choose two.)

  • A. creating a bitmap index on the COUNTRY_ID column
  • B. regathering statistics on the CUSTOMERS table
  • C. gathering statistics on the COUNTRY_IDX index
  • D. creating a histogram on the COUNTRY_ID column
  • E. increasing the size of the PGA
  • F. creating an SQL profile
  • G. creating a KEEP cache
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
adz07
1 year ago
i think D and F ?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago