[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-064 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-064
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-064.html

Oracle Database 12c: Performance Management and Tuning

Question No: 21

Examine the parameters set for your database instance:

Ensurepass 2018 PDF and VCE

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.)

  1. Create the KEEP cache and cache the tables used in the queries.

  2. Set the CURSOR_SHARING parameter to FORCE.

  3. Use bind variables instead of literals.

  4. Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.

  5. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

Answer: B,E

Question No: 22

To investigate the slow response time of queries on the TRANS table, you gathered the table statistics and executed the query:

Ensurepass 2018 PDF and VCE

The table is stored in a tablespace that has Automatic Segment Space Management (ASSM) enabled. The tablespace is created with a standard block size of 8192 bytes.

Which three can be reasons for the slow response time of the queries? (Choose three.)

  1. Row size is too large to fit into a single block during insert operations.

  2. Row moves from one data block to another data block because the row grows too large to fit in the original block.

  3. The table is subject to frequent insert, update, and delete DML activity leading to sparsely populated blocks.

  4. The value of PCTUSED is set to a value lower than the default, causing row changing.

  5. The value of PCTFREE is set to a value lower than the default, causing row chaining.

Answer: A,B,C

Question No: 23

You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services.

You execute the command to enable tracing of the ORCL1 service:

Ensurepass 2018 PDF and VCE

Which two statements are true? (Choose two.)

  1. A single trace file is generated for all sessions mapped to the ORCL1 service.

  2. SQL trace is enabled for all modules and actions for sessions mapped to the ORCL1 service.

  3. An SQL trace file is generated for each session that maps to the ORCL1 service.

  4. An SQL trace file is generated for each of the modules using the ORCL1 service.

  5. SQL trace is not enabled for the service because a module name is not specified.

Answer: A,C

Question No: 24

For which three problem categories does Automatic Database Diagnostic Monitor (ADDM) provide analysis and recommendations by default? (Choose three.)

  1. for network stack-related bandwidth contention

  2. for concurrency issues because of buffer busy problems

  3. for high-load PL/SQL execution and compilation, and high-load Java usage

  4. for application-level lock contention.

Answer: B,C,D

Question No: 25

Examine the partial AWR report taken for a time period of 60 minutes:

Ensurepass 2018 PDF and VCE

Which two inferences can you draw from this report? (Choose two.)

  1. The database user calls are issuing frequent explicit commits.

  2. The CPUs are busy executing server processes and background processes for a considerable amount of CPU time.

  3. The database user calls are spending most of their time in I/O for single block reads.

  4. The database user calls are spending most of their time waiting for sessions that are in more important consumer groups.

Answer: B,C

Question No: 26

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.)

  1. to reduce the elapsed time between two successive user calls from a session.

  2. to decrease the number of concurrent users during replay

  3. to increase the number of concurrent users during replay

  4. to reduce the time of replay

  5. to decrease the wait for a query, caused by noncommitted transactions

Answer: C,D,E

Question No: 27

Examine the parameters set for your database instance:

Ensurepass 2018 PDF and VCE

You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in the SQL Plan Management Base.

Which action is taken by the optimizer? (Choose the best answer.)

  1. It adds the newly generated plan as an accepted but non-fixed plan.

  2. It adds the newly generated plan as enabled and accepted.

  3. It adds the newly generated plan as enabled but not accepted.

  4. It adds the newly generated plan as a fixed plan, which will be used each time the SQL statement is executed.

Answer: B

Question No: 28

You are administering a database that supports an OLTP workload. CURSOR_SHARING

is set to EXACT for the instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE clause, causing a large number of hard parses to occur.

Which four statements would be true if you use bind variables for these queries? (Choose four.)

  1. Mutex contention in the library cache will be reduced.

  2. The optimizer will use one parent cursor and one child cursor for each SQL statement with different literal values.

  3. Hard parses will be reduced for the queries.

  4. The optimizer will use bind peeking and subsequent execution of the queries will always generate the same plans irrespective of the cardinality.

  5. The optimizer will generate the same plan for all bind values if no histograms exist on the columns used in the WHERE clause of these queries.

  6. The optimizer will use bind peeking and use the literal value to determine the execution plan for these queries.

Answer: A,C,D,E

Question No: 29

Examine the query and its output:

Ensurepass 2018 PDF and VCE

Which two statements are true? (Choose two.)

  1. Session 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.

  2. Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on the client process.

  3. Session 3346 is in wait state because it wants to lock a row in a block in which other sessions have already locked rows, and there is no free ITL slot available in this block.

  4. Session 3346 is in wait state because either it is waiting to update a row that is locked

    by another session or another session is trying to insert the same key value in a UNIQUE index.

  5. Session 4208 is definitely idle and should be killed to free network resources.

Answer: A,D

Question No: 30

Examine the query and its output:

Ensurepass 2018 PDF and VCE

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

  1. The db file scattered read event has occurred 104 times in this session for file# 12.

  2. The session has completed performing a full table scan.

  3. The SQL statements in this session are performing excessive disk reads.

  4. The multiblock factor is 8 for this I/O but it could vary for the other I/O events.

Answer: A,C

100% Ensurepass Free Download!
Download Free Demo:1z0-064 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-064 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *