1z1-084 by Oracle Valid Free Exam Practice Test

Question 1

Users complain about slowness and session interruptions. Additional checks reveal the following error in the application log:

Which file has additional information about this error?

A. Alert log B. ASH report C. SQL trace file automatically generated by the error D. Session trace file SQL trace file automatically generated by the error

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

Database performance degraded between 23:15 and 23:30 for the last three nights. The awr snapshot interval is one hour. The AODM report contains nothing about this performance problem.
With which tool can you further analyze this problem?

A. Active Session History report B. SQL Performance Analyzer C. SQL Tuning Advisor D. AWR Compare Periods report

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Which two statements are true about cursor sharing?

A. Setting Cursor_sharing to FORCE can result in a plan that is suboptimal for the majority of values bound to a bind variable when executing a cursor with one or more bind variables. B. Adaptive Cursor Sharing requires histograms on filtered columns, used in equality predicates, to allow different execution plans to be generated for statements whose bound values would normally generate different plans at hard parse time. C. Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used. D. Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache. E. Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.

Correct Answer: A,C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

Which three statements are true about server-generated alerts?

A. They may contain suggestions for correcting the identified problems. B. They provide notifications but never any suggestions for correcting the identified problems. C. They can be viewed only from the Cloud Control Database home page. D. They are logged in the alert log. E. They are notifications from the Oracle Database Server of an existing or impending problem. F. Their threshold settings can be modified by using DBMS_SERVER_ALERT.

Correct Answer: A,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

The CURS0R_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an awr report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses?

A. Set the CURSOR_SHARING parameter to FORCE. B. Increase the size of the library cache. C. Create the RECYCLE cache and cache tables accessed by the SQL statements. D. Create the KEEP cache and cache tables accessed by the SQL statements. E. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.

Correct Answer: A,B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

You must configure and enable Database Smart Flash Cache for a database.
You configure these flash devices:

Examine these parameter settings:

What must be configured so that the database uses these devices for the Database Smart Flash Cache?

A. Set DB_FLASH_CACHE_SIZE parameter to 192G. B. Set DB_FLASH_CACHE_SIZE to 192G and MEMORY_TARGET to 256G. C. Set DB_FLASH_CACHE_SIZE parameter to 128G, 64G. D. Disable Automatic Memory Management and set SGA_TARGET to 256G. E. Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128G.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle Database 19c Performance and Tuning Management - 1z1-084 Exam Practice Test