Free Oracle 1z1-084 Exam Dumps Questions & Answers

Which two actions can cause invalidation or loss of one or more results in the SQL Query Result Cache?

• A.  result_cache_max_size is set dynamically to 0.
• B.  One or more results were aged out of the result cache.
• C.  A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.
• D.  A request was made by the RCBG background of a non-RAC database.
• E.  Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?

• A.  recommendations regarding partitioning the tables
• B.  recommendations regarding the creation of materialized views
• C.  recommendations regarding the creation of additional indexes
• D.  recommendations regarding rewriting the SQL statements
• E.  recommendations regarding the creation of SQL Patches

A database supporting a mixed workload is hosted on a server with 64 CPUs.
A large number of free buffer waits and buffer busy waits occur affecting performance.
The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.
Examine these parameter settings:

Which two actions can help reduce the number of these waits7

• A.  Increasing the size of MEMORYTARGET
• B.  increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT to 128
• C.  increasing the value of DBWRITERPROCESSES to 64,
• D.  setting dbwr_io_slaves to 64
• E.  reducing the values of DB_FILE_MULTILOCK_READ_COUNT to 64

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?

• A.  When WAIT TIME is high, instance tuning may improve performance.
• B.  Parse Time Elapsed accounts for successful soft and hard parse operations only.
• C.  The proportion of WAIT TIME to CPU TIME always increases with increased system load.
• D.  Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.
• E.  Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.
• F.  DB Time accounts for all time used by background processes and user sessions.

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

• A.  3
• B.  52
• C.  1
• D.  5