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 37
Examine this list of possible tasks:
1. Ensure that STATISTICS_LEVEL is set to TYPICAL or ALL.
2. Ensure that TIMED_STATISTICS is set to TRUE.
3. Set MAX_DUMP_FILE_SIZE to UNLIMITED and DIAGNOSTIC_DEST to an appropriate destination.
4. Ensure that SQL_TRACE is set to TRUE.
5. Enable tracing at the database instance level by using the DBMS_MONITOR.DATABASE_TRACE_ENABLE procedure.
6. Enable tracing in the required session by using the DBMS_SESSION.SET_SQL_TRACE procedure.
7. Run TKPROF with the EXPLAIN parameter on the output trace file.
8. Run the trcsess utility on the output trace files, and then run TKPROF on the output of the trcsess utility.
Select the minimum tasks to perform, in the correct order, to generate both a formatted trace file with timing information and an explain plan for each SQL statement for all sessions. (Choose the best answer.)
A. 1, 2, 5, 8
B. 1, 3, 6, 7
C. 2, 4, 5, 8
D. 1, 3, 4, 5, 6, 7
E. 1, 2, 4, 8
Answer: C
QUESTION 38
Examine the partial AWR report taken for a time period of 60 minutes:
Which two inferences can you draw from this report? (Choose two.)
A. The database user calls are issuing frequent explicit commits.
B. The CPUs are busy executing server processes and background processes for a considerable amount of CPU time.
C. The database user calls are spending most of their time in I/O for single block reads.
D. The database user calls are spending most of their time waiting for sessions that are in more important consumer groups.
Answer: BD
QUESTION 39
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries. You want to set a priority for the workload generated by the ERP application and optimize resource usage for them. Which three objectives can be achieved by the Resource Manager? (Choose three.)
A. Limiting the amount of time that a session is idle and blocking other sessions of the ERP application.
B. Limiting the amount of undo generated by operations performed by sessions created by the ERP application.
C. Creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload.
D. Allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application.
E. Limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database.
Answer: BDE
QUESTION 40
Examine the partial TKPROF output for an SQL statement:
Which two inferences can definitely be made from this output? (Choose two.)
A. Array fetch operations were not performed for this query.
B. No hard parse was performed for this query.
C. The number of logical I/Os is almost equal to the number of physical I/Os.
D. Another transaction held a shared lock on the table, thereby causing a significant delay.
Answer: BD
QUESTION 41
Examine the command to change a parameter value from the default to 50:
SQL> ALTER SYSTEM SET OPTIMIZER_INDEX_COST_ADJ = 50;
What is the effect of changing the value of the parameter? (Choose the best answer.)
A. It influences the optimizer to use full table scans instead of index scans as the estimated cost of full table scan is reduced.
B. It influences the optimizer to use bitmap indexes as the estimated cost of conversion from bitmap to rowid is reduced.
C. It influences the optimizer to always use fast full index scans as the estimated cost of using an index is reduced.
D. It influences the optimizer to use indexes instead of full table scans as the estimated cost of using an index is reduced.
Answer: A
Explanation:
http://www.dba-oracle.com/oracle_tips_cost_adj.htm
QUESTION 42
You want to Increase the number of SQL statements that are cached in memory. Which memory structure size should be increased?
A. Large pool
B. Shared pool
C. Buffer Cache
D. Program Global Area
Answer: B
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