Online Access Free 1z1-064 Practice Test

The SALES table has over one million rows. Statistics for the SALES table and its dependent objects are gathered by the Oracle AutoTask task during a predefined maintenance window.
Examine the query:

Which two actions can improve the accuracy of cardinality estimates for this query?

• A.ensuring that histograms exist for the CUST_ID and PROD_ID columns
• B.setting the OPTOMIZER_DYNAMIC_SAMPLING parameter to 4 to augment the default standard statistics
• C.setting the FORCE parameter of the GATHER_*_STATS procedure to TRUE and gathering statistics for the SALES table and its dependent objects
• D.gathering system statistics during peak workload time to augment the standard statistics

To diagnose the performance degradation of your production database, you execute these queries:



Segment space management is manual for some of the tablespaces.
What can be the reason for the performance degradation?

• A.The database writer (DBWR) process is processing buffers at a rate that is faster than the rate at which the I/O system can return the buffers.
• B.The buffer cache is undersized.
• C.There are too many disk sort operations.
• D.PGA is undersized
• E.Contention is caused by freelist management.

Which two situations can lead to sparsely populated index blocks? (Choose two.)

• A.Online table move operations are performed frequently on a table with indexes.
• B.Values in an indexed column are inserted using monotonically incrementing sequences.
• C.Bulk delete operations are performed on a table with indexes.
• D.Data is frequently inserted using direct path load into a table with an index.
• E.Indexed columns in a table are frequently updated.

Which two statements are true about wait events?

• A.Wait event countries are incremented by the server process that waits.
• B.A wait event can be defined in multiple wait classes.
• C.A single resource wait event may be recorded as multiple waits, depending on the number of session timeouts during that wait.
• D.Wait event statistics are cumulatively collected only at the instance level.
• E.Wait events for an instance include statistics for both background and foreground processes.

Examine the parameters set for your database instance:

You are asked by a developer to create a table for an application with these requirements:
Which attributes are the best for the tablespace in which this table should be created? (Choose the best answer.)

• A.Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE attribute.
• B.Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.
• C.Create it in a locally managed tablespace with manual segment space management.
• D.Create it in locally managed tablespace with ASSM enabled and an additional freelist.