Online Access Free 1z1-064 Practice Test

Which two statements are true about ADDM? (Choose two.)

• A.It analyzes the performance of a database instance based on the time period covered by the most recent AWR snapshot, and generates recommendations based on hard-coded criteria.
• B.It can analyze performance issues that occurred in past events provided they fall within the AWR retention period.
• C.It documents only those components and wait classes that are significantly impacting the performance of the database.
• D.It first identifies the performance symptoms, and then refines them to reach the root cause with the singular aim of reducing the DB CPU metric.
• E.ADDM resource utilization and cost of analysis depends on the actual load on the database and the number of performance problems analyzed.

You are administrating a database on a symmetric multiprocessing (SMP) machines. The database supports a mixed workload. You notice a large number of free buffer waits and buffer busy waits that are affecting the performance of the database. To mitigate the issue, you increase the buffer cache size, but after some time, you notice the same wait events with a high number.
Examine the parameters set for the instance:

Which two actions would you recommend to resolve the issue?

• A.increasing the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter
• B.configuring the KEEP buffer pool
• C.decreasing the idle time resource limit in the profile assigned to users
• D.increasing the number of DBWn processes
• E.enabling asynchronous I/O for the file system

You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE clause, causing a large number of hard parses to occur.
Which four statements would be true if you use bind variables for these queries? (Choose four.)

• A.The optimizer will generate the same plan for all bind values if no histograms exist on the columns used in the WHERE clause of these queries.
• B.The optimizer will use bind peeking and subsequent execution of the queries will always generate the same plans irrespective of the cardinality.
• C.Mutex contention in the library cache will be reduced.
• D.The optimizer will use bind peeking and use the literal value to determine the execution plan for these queries.
• E.The optimizer will use one parent cursor and one child cursor for each SQL statement with different literal values.
• F.Hard parses will be reduced for the queries.

Which two are prerequisites for running the I/O calibration tool? (Choose two.)

• A.The database instance must be started using an SPFILE.
• B.For determining latency time, the STATISTICS_LEVEL parameter must be set to TYPICAL or ALL.
• C.The database must be in MOUNT state.
• D.The disks to be tested must be configured to use asynchronous I/O for data files.
• E.The database should be opened in restricted mode.

You want to capture the performance of your database during the last ten days of the first quarter of the current financial year, so that you can compare this performance against the remaining quarter ends of the current financial year.
Which method should you use? (Choose the best answer.)

• A.Use fixed baseline templates to create a new moving window baseline and set relevant warning alerts that are computed as a percentage multiple of the maximum value observed for the data in the moving window baseline.
• B.Create a new moving window baseline and enable adaptive thresholds for relevant metrics.
• C.Create a static baseline that can be used with AWR compare reports.
• D.Use a repeating baseline template to create and drop baselines based on a repeating time schedule and set adaptive thresholds at a high significance level.