Latesttests
2018 Jan Oracle Official New Released 1z0-064
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-064.html

Oracle Database 12c: Performance Management and Tuning

Question No: 1

Examine the parameters set for your database instance:

Latesttests 2018 PDF and VCE

You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads at different times. You notice in an ADDM report that the shared pool is inadequately sized. You resize the shared pool by decreasing the sizes of other pools, which results in inadequate sizes for other pools. You want to automate the sizing of SGA components.

Which two actions should you perform? (Choose two.)

  1. Set the SGA_TARGET parameter equal to SGA_MAX_SIZE.

  2. Set the SGA_TARGET parameter to the sum of DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE.

  3. Set the MEMORY_MAX_TARGET parameter to the sum of DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE.

  4. Set DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE to their minimum required values.

  5. Set the PGA_AGGREGATE_TARGET parameter to 0 and the SGA_TARGET parameter to 1.5G.

Answer: A,E

Question No: 2

Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currently cached in the library cache to receive recommendations about the usage of indexes and materialized views.

What should you do to achieve this? (Choose the best answer.)

  1. Create an STS for the queries cached in the library cache and submit it as an input to SQL Tuning Advisor.

  2. Create an STS for the queries cached in the library cache and submit it as an input to SQL Access Advisor.

  3. Capture the workload in an STS and submit to SQL Tuning Advisor for recommendations.

  4. Create an STS for the queries cached in the library cache and submit it as an input to SQL Performance Analyzer.

Answer: D

Question No: 3

In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert.

What is the outcome? (Choose the best answer.)

  1. It generates an error because the warning threshold cannot exceed 100%.

  2. It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.

  3. It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.

  4. It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.

  5. It generates an alert when 1 in 100 observations for an observed metric exceeds the 99th percentile value as measured over the fixed baseline.

Answer: A

Question No: 4

In which three situations can dynamic statistics be used? (Choose three.)

  1. when the sampling time is a small fraction of the total time for a query

  2. when an execution plan is suboptimal because of complex predicates

  3. when extended statistics are not available for SQL statements that use complex

    predicates

  4. when a query is on a partitioned table with a global index

  5. when index statistics are missing on a column that is used in SQL statements with highly selective filters

Answer: A,B,C

Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341

Question No: 5

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

  1. It is automatically invoked whenever the AWR Compare Period report is invoked.

  2. It is automatically invoked whenever ADDM is run by default.

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

  4. It can be used to create a comparison report between the Database Replay workload capture report and the replay report.

Answer: C,D

Question No: 6

You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing multipass work area executions and the I/O contention on one of the temporary tablespaces is very high.

Which two can be possible resolutions for this issue? (Choose two.)

  1. Increase the size of the large pool.

  2. Increase the value of the PGA_AGGREGATE_TARGET parameter.

  3. Create a temporary tablespace group and assign it to users.

  4. Increase the value of the PGA_AGGREGATE_LIMIT parameter.

  5. Create another temporary tablespace and assign it to users.

  6. Enable temporary undo.

Answer: C,D

Question No: 7

Which three statements are true about the interpretation of an execution plan? (Choose three.)

  1. The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.

  2. The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.

  3. A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.

  4. An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.

  5. A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.

Answer: B,D,E

Question No: 8

You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:

->analyze and compare the overall database workload with concurrency and transaction characteristics

->find SQL statements that might get regressed because of the upgrade

->analyze execution plans for SQL statements for which performance might get regressed

->analyze the impact of new schema objects on database performance

Which two tools would you recommend to achieve the objective? (Choose two.)

  1. Database Replay

  2. SQL Tuning Advisor

  3. SQL Access Advisor

  4. Automatic Database Diagnostic Monitor (ADDM) compare periods report

  5. SQL Performance Analyzer

  6. Automatic Workload Repository (AWR) compare periods report

Answer: B,E

Question No: 9

Examine the Load Profile section of an AWR report:

Latesttests 2018 PDF and VCE

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

  1. The values for Redo size and Block changes imply that only updates were performed by transactions.

  2. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.

  3. The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.

  4. The values for SQL Work Area and User calls imply that only sort-based operations were performed.

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

Answer: B,D

Question No: 10

You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.

Which action would you take to achieve this? (Choose the best answer.)

  1. Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.

  2. Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.

  3. Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.

  4. Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.

Answer: C

100% Free Download!
Download Free Demo:1z0-064 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-064 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE