1z0-064 무료 덤프문제 온라인 액세스

In the CUSTOMERS table, the values in the CUST_STATE column are dependent on the values in the COUNTRY_ID column. You want to make the optimizer aware of this dependency when these columns are used together in WHERE clause predicates that contain equalities or in-lists.
Which two methods achieve this? (Choose two.)

• A.creating column group statistics, regathering statistics, and ensuring that histograms exist on both these columns
• B.gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics
• C.setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true
• D.using SQL plan directives to generate an optimal plan

Examine the Time Model Statistics section of an AWR report:

Which two inferences can be definitely derived from this section? (Choose two.)

• A.The DB CPU time was not spent exclusively for processing SQL statements.
• B.The available CPU resources were not utilized to their maximum capacity.
• C.New child cursors were created because of new bind values or usage of literal values as well as different bind types or sizes.
• D.All sequence numbers used during this AWR time interval were cached.
• E.A large number of connected user sessions were idle.

Examine the partial Activity Over Time section of an Active Session History (ASH) report:

Which two inferences are correct? (Choose two.)

• A.In the second time slot, five different sampled sessions were using the CPU.
• B.In the first time slot, five different sampled sessions were connected to the database instance.
• C.In the second time slot, 0.14% of the time was spent on the CPU.
• D.In the first time slot, only one sampled session was using the CPU.
• E.In the second time slot, out of the nine sampled sessions connected to the database instance, only one sampled session was idle at the time of report generation.

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)

• A.The values for Redo size and Block changes imply that only updates were performed by transactions.
• B.The values for Logical reads and Physical reads imply that the number of disk reads per second was less than the total number of DB block reads and consistent gets per second.
• C.The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
• D.The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
• E.The values for SQL Work Area and User calls imply that only sort-based operations were performed.

Which three statements are true about the TEST EXECUTE method of the SQL Performance Analyzer?

• A.An execution plan and statistics are computes for each SQL statement in the STS.
• B.The SQL statements in the SQL Tuning Set (STS) are executed at least twice for both pre-change and post-change trials.
• C.An execution plan and statistics are generated for SQL statements only in the pre-change trial.
• D.The execution statistics generated for SQL statements are analyzed to check whether they have improved or regressed.
• E.The SQL statements in the STS are compared only on elapsed time for the pre-change and post-change trials.