Free Preparation Discussions
MENU
Oracle 1Z0-064 Exam Questions
- Topic 1: Diagnose and resolve performance issues related to temporary tablespace/ Diagnose performance problems using V$ views
- Topic 2: Understand and configure the Database Resource Manager/ Analyze database performance using AWR reports
- Topic 3: Diagnose and resolve performance issues related to PGA/ Monitor performance using metric thresholds and alerts
- Topic 4: Diagnose and resolve performance issues related to the buffer cache/ Use AWR baselines to monitor performance
- Topic 5: Use Database Replay to check impact of system change on performance/ Diagnose performance issues using ASH reports
- Topic 6: Use Automatic Segment Space Management to optimize space management/ Diagnose performance issues using ADDM
- Topic 7: Configure parameters to influence the optimizer/ Implement Real-Time Database Operation Monitoring
- Topic 8: Use SQL Performance Analyzer to test the impact of database changes/ Configure and use services to monitor database performance
- Topic 9: Diagnose and resolve performance issues related to the shared pool/ Monitoring Real-Time Database Operation
- Topic 10: Use SQL Profiles and Advisors to tune SQL statements/ Explain how statistics influence the optimizer
- Topic 11:
Free Oracle 1Z0-064 Exam Actual Questions
Note: Premium Questions for 1Z0-064 were last updated On 10-08-2021 (see below)
Which two statements are true about gathering statistics? (Choose two.)
Which two statements are true about viewing the details of Real-Time Database Operations? (Choose two.)
In the CUSTOMERS table, the values in the CUST_STATE column are dependent on the values in the COUNTRY_ID column. You want to make the optimizer aware of this dependency when these columns are used together in WHERE clause predicates that contain equalities or in-lists.
Which two methods achieve this? (Choose two.)
Your database supports a DSS 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 several INSERT, UPDATE, and DELETE operations, significantly altering the data in the table.
View the Exhibit to examine the query and its execution plan.
Which three options would improve the performance of the query? (Choose three.)
You are administering a database that supports a mixed workload. You upgrade your database from Oracle Database 11g to 12c and after the upgrade, users complain about degraded performance of some queries. The SQL plan baselines imported from the previous version are present for the queries and are loaded to the SQL Management Base as accepted plans. On further investigation, you find that better plans are generated but not used by the optimizer.
Examine the parameters set for the instance:
Which three tasks would you perform to improve the performance of these queries? (Choose three.)
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!