web analytics

New 1Z0-064 Dumps with VCE and PDF from PassLeader (Question 31 – Question 36)

PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)

BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2

QUESTION 31
Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)

A.    Distributing available CPU by allocating percentages of CPU time to different users and applications.
B.    Limiting the degree of parallelism of any operation performed by members of a group of users.
C.    Limiting queries based on resource consumption of runaway sessions or calls that consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time.
D.    Limiting the number of concurrent sessions for a user.
E.    Limiting the number of user sessions allowed to be concurrently active within a group of users.
F.    Limiting the number of parallel executions that can be executed by a user.

Answer: ABCE

QUESTION 32
Which two statements are true about Compare Period ADDM? (Choose two.)

A.    It is automatically invoked whenever the AWR Compare Period report is invoked.
B.    It is automatically invoked whenever ADDM is run by default.
C.    It verifies if there is any change in the workload or average resource consumption by the SQL executed during the two specified time periods, to ensure 100% accuracy.
D.    It can be used to create a comparison report between the Database Replay workload capture report and the replay report.

Answer: CD

QUESTION 33
Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)

A.    Decreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the cost of index probes for DSS workloads.
B.    A full table scan can become cheaper than index scans if the database instance has a high enough DB_FILE MULTIBLOCK_READ_COUNT for both OLTP and DSS workloads.
C.    Increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the costing of an index probe that is done in conjunction with a nested loop for OLTP workloads.
D.    In DSS workloads where full table scans may run in parallel and bypass the buffer cache, decreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the cost of full table scans.
E.    Increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the cost of full table scans and can result in the optimizer choosing a full table scan over an index scan for both OLTP and DSS workloads.

Answer: BE

QUESTION 34
Examine the partial Activity Over Time section of an Active Session History (ASH) report:
passleader-1z0-064-dumps-341
Which two inferences are correct? (Choose two.)

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

Answer: BE

QUESTION 35
A senior DBA asks you to decrease the values of the connect_time_scale and think_time_scale replay processing parameters to 50 to preprocess the workload for replay. What three could be reasons for this change? (Choose three.)

A.    To reduce the elapsed time between two successive user calls from a session.
B.    To decrease the number of concurrent users during replay.
C.    To increase the number of concurrent users during replay.
D.    To reduce the time of replay.
E.    To decrease the wait for a query, caused by noncommitted transactions.

Answer: CDE

QUESTION 36
Examine the parameters set for your database instance:
passleader-1z0-064-dumps-361
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.    Create the KEEP cache and cache the tables used in the queries.
B.    Set the CURSOR_SHARING parameter to FORCE.
C.    Use bind variables instead of literals.
D.    Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.
E.    Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

Answer: BC


PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)

BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2