Online Access Free 1Z0-054 Practice Test

Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.

• A.because retrieving these rows requires more than one data block to be accessed
• B.because it is not possible to use indexes to retrieve these rows
• C.because the ROWID changes for these rows
• D.because the rows force queries to use temporary segments while retrieving them
• E.because these rows make existing indexes invalid

View the Exhibit and examine the content of the V$MEMORY_RESIZE_OPS view.Which two conclusions can you draw? (Choose two.)

• A.The Shared Pool grew in IMMEDIATE mode to avoid an out-of-memory error.
• B.Automatic Shared Memory Management (ASMM) is enabled but not AMM.
• C.The Default Buffer Cache grew in DEFERRED mode to avoid an out-of-memory error.
• D.Automatic Memory Management (AMM) is enabled.
• E.The memory is transferred in IMMEDIATE mode only if there are entirely empty granules available in other components.

View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle.Which two can be inferred from the output? (Choose two.)

• A.increase in number of COMMITS and ROLLBACKS per second
• B.increase in the number of active sessions
• C.unable to grow the database buffer cache as per demand
• D.increase in the number of processes waiting for the buffer busy wait event

Examine the following block:
BEGIN
DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE (baseline_name => 'peak baseline',
cascade => FALSE, dbid => 3310949047);
END;
Why would you use the FALSE value for the CASCADE parameter while dropping the baseline?

• A.because it does not remove snapshots associated with the baseline
• B.because it does not remove the baseline from the performance page if it appears there
• C.because it does not drop the template that is used to create the baseline
• D.because it does not remove the Automatic Database Diagnostic Management (ADDM) results from the Automatic Workload Repository (AWR) that were generated using the baseline

View the Exhibit and examine the plans in the SQL plan baseline.You observe that the last two
SELECT statements (outlined in red and blue) are identical, but have two different plans. Also, the second plan (in blue) is not being used by the optimizer.Which two steps do you perform to ensure that the optimizer uses the second plan (in blue) if the plan is more efficient? (Choose two.)

• A.Use SQL Access Advisor to tune the plan.
• B.Use the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function to evolve the plan.
• C.Use SQL Tuning Advisor to tune the plan.
• D.Mark the second plan (in blue) as fixed.