Online Access Free 1Z0-084 Practice Test

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 value of DBWRITERPROCESSES to 64,
• B.Increasing the size of MEMORYTARGET
• C.setting dbwr_io_slaves to 64
• D.reducing the values of DB_FILE_MULTILOCK_READ_COUNT to 64
• E.increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT to 128

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 SQL Patches
• D.recommendations regarding the creation of additional indexes
• E.recommendations regarding rewriting the SQL statements

SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?

• A.
• B.
• C.
• D.
• E.
• F.
• G.

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 to 192G and MEMORY_TARGET to 256G.
• B.Disable Automatic Memory Management and set SGA_TARGET to 256G.
• C.Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128G.
• D.Set DB_FLASH_CACHE_SIZE parameter to 192G.
• E.Set DB_FLASH_CACHE_SIZE parameter to 128G, 64G.

Which three statements are true about using the in Memory (IM) column store?

• A.It can improve OLTP workload performance by avoiding the use of indexes.
• B.It does not improve performance for queries that use join groups on columns from different tables.
• C.It does not improve performance for queries using cached results of function evaluations on columns from the same table.
• D.It does not improve performance for queries using user-defined virtual column results.
• E.It improves performance for queries joining several tables using bloom filter joins.
• F.It does not require all database data to fit in memory to improve query performance.