Oracle Database 12c Certified: 1Z0-064 Dumps Questions

1Z0-064 Oracle Database 12c: Performance Management and Tuning Certification exam is a required exam for Oracle Certified Expert, Oracle Database 12c: Performance Management and Tuning (Option 1) Certification. This certification is mainly for database administrators, support engineers and technical consultants, who can gain the certification to demonstrate a fluency in and strong understanding of Oracle Database performance analysis, management and tuning for optimal performance in a complex environment. Oracle 1Z0-064 dumps questions online will be the most valid study materials to ensure that you can pass Oracle Database 12c: Performance Management and Tuning 1Z0-064 exam in the first try.

Here you can read 1Z0-064 free dumps questions first.

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

 
 
 
 
 

2. Examine the partial TKPROF output for an SQL statement:

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

 
 
 
 
 

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

 
 
 
 
 

4. You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and

12:00 PM for three months and automatically remove the older AWR data every fortnight.

How would you achieve this? (Choose the best answer.)

 
 
 
 
 

5. Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)

 
 
 
 
 
 

6. 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 ORCL1service:

Which two statements are true? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 

8. You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them.

Which two tasks would you perform to test the new statistics? (Choose two.)

 
 
 
 
 
 

9. You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database.

You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.

Which two methods would you use to achieve this? (Choose two.)

 
 
 
 
 
 

10. You recently joined a new team administering a database.

You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.

You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.

Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)

 
 
 
 
 
 
 

11. Examine the Time Model Statistics section of an AWR report:

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

 
 
 
 
 

12. Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:

What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)

 
 
 
 
 

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

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

 
 
 
 

14. For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace.

You want to control the usage of the UNDO tablespace only for these user sessions.

How would you avoid the issue from repeating in future? (Choose the best answer.)

 
 
 
 

15. Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)

 
 
 
 
 

16. You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics for objects accessed by the query and test query performance with the new statistics without affecting other sessions connected to the instance.

The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.

Which two actions would you take to accomplish the task? (Choose two.)

 
 
 
 
 
 

17. Examine the structure of the EMPLOYEES table.

EMPLOYEE_ID is the primary key. No other indexes exist on this table.

View the Exhibit to examine the commands and their output.

Which two actions should you perform to make the cursor bind aware? (Choose two.)

 
 
 
 
 
 

18. Examine the output of the query executed to diagnose the reason for performance degradation of queries:

Which three factors will you investigate further to identify the cause of the performance degradation? (Choose three.)

 
 
 
 
 

19. Examine the parameters set for your database instance:

You are asked by a developer to create a table for an application with these requirements:

– The table will be used for a DSS application.

– High volume bulk loads will be performed.

– The table will be used to store archival data on which large full-table scans (FTS) will be performed.

Which attributes are the best for the tablespace in which this table should be created? (Choose the best answer.)

 
 
 
 

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

 
 
 
 
 
 

21. Examine the query and its output:

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

 
 
 
 

22. You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them. You notice that performance is degraded because of excessive generation of undo due to a large number of transactions on the global temporary tables.

What is the recommended action to improve performance? (Choose the best answer.)

 
 
 
 
 

23. Your database supports an OLTP system.

Examine the parameter values configured in your database:

sga_max_size = 480M

sga_target = 480M

pga_aggregate_target = 160M

The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333.

You execute the commands:

SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(‘SH’,‘CUSTOMERS’);

PL/SQL procedure successfully completed.

SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);

Index created.

You then perform a series of INSERT, UPDATE, and DELETE operations on the table.

View the Exhibit to examine the query and its execution plan.

Which two options can improve the performance of the query without significantly slowing down the DML operations? (Choose two.)

 
 
 
 
 
 
 

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

 
 
 
 
 

25. Examine the query and its output:

Which two statements are true? (Choose two.)

 
 
 
 
 

26. In which three situations does DB time always increase? (Choose three.)

 
 
 
 
 

27. Which two situations can lead to sparsely populated index blocks? (Choose two.)

 
 
 
 
 

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

 
 
 
 

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

 
 
 
 

30. You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latest AWR report and find a large number of latch: shared poolwait events and also a high percentage of the hard parse elapsed time.

Which two can be reasons for this? (Choose two.)

 
 
 
 
 

31. Which two result in the least internal fragmentation within segments and the least external fragmentation within tablespaces? (Choose two.)

 
 
 
 
 
 

32. Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)

 
 
 
 
 

33. Examine the parameters set for your database instance:

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

 
 
 
 
 

34. Which two statements are true about DB timein V$SYS_TIME_MODEL? (Choose two.)

 
 
 
 
 

35. Examine the parameters set for your database instance:

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

 
 
 
 

36. Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expressions are using materialized views. You notice that some queries are performing poorly because they are not benefiting from query rewrites.

Which three actions would you take to improve the performance of queries? (Choose three.)

 
 
 
 
 
 
 
 

37. Examine the parameters set for a database instance:

The database supports a mixed workload.

Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:

Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)

 
 
 
 
 
 

38. In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level.

Which two statements are true? (Choose two.)

 
 
 
 

39. Examine the parameters set for a database instance supporting a mixed workload:

The database instance supports shared server and dedicated server connections simultaneously.

Users complain about increased response times of a few DSS queries. During investigation, you execute the queries:

Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)

 
 
 
 
 
 

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

 
 
 
 

Oracle WebLogic Administration 1Z0-134 Real Exam Dumps
Oracle Autonomous Database Cloud 2019 Specialist 1Z0-931 Dumps Questions

Add a Comment

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