Online Access Free 1z1-064 Practice Test

Examine the parameters set for your database instance:

You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some queries. While diagnosing, you notice a large number of hard parses occurring for several syntactically almost identical SQL statements that differ only in literal values in the WHERE clause.
Which two actions would you recommend to improve performance? (Choose two.)

• A.Use bind variables instead of literals.
• B.Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.
• C.Set the CURSOR_SHARING parameter to FORCE.
• D.Create the KEEP cache and cache the tables used in the queries.
• E.Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.

Which three actions should you perform to reduce shared pool fragmentation and avoid the "ORA-04031: unable to allocate .... bytes of shared memory" error for the shared pool? (Choose three.)

• A.Configure the Server Result Cache.
• B.Use more anonymous procedures.
• C.Standardize the type, size, and naming conventions for bind variables and spacing conventions for SQL statements and PL/SQL blocks.
• D.Use DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and SYS.DIUTIL packages and frequently executed compiled triggers.
• E.Configure shared server mode.
• F.Identify the packages or procedures that are causing the "ORA-04031:unable to allocate....bytes of shared memory" error and use the DBMS_SHARED_POOL.KEEP to keep them in the shared pool.

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

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, only one sampled session was using the CPU.
• C.In the second time slot, 0.14% of the time was spent on the CPU.
• D.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.
• E.In the first time slot, five different sampled sessions were connected to the database instance.

Which four statements are true about Consolidated Database Replay?

• A.Multiple database workloads can be replayed only if both the capture and replay databases have the same database version.
• B.Consolidated workloads from one or multiple databases can be replayed concurrently on a single system.
• C.Multiple database workloads can be replayed only if both the capture and replay databases are on the same operating system.
• D.Multiple replay schedules can be defined and any existing replay schedules can also be used.
• E.A subset of the captured workload can be replayed on a test system.
• F.The replay starts simultaneously for all participating workload captures if no order is defined in the replay schedule.
• G.The number of replay clients must be equal to the number of captured workloads.