Act now and download your Oracle 1Z0-064 test today! Do not waste time for the worthless Oracle 1Z0-064 tutorials. Download Leading Oracle Oracle Database 12c: Performance Management and Tuning exam with real questions and answers and begin to learn Oracle 1Z0-064 with a classic professional.
2021 Aug 1Z0-064 free exam
Q51. Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
A. Use the Resource Manager.
B. Enable SQL Trace at the session level.
C. Create a service.
D. Use a dedicated server configuration.
E. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.
Answer: B,E
Q52. Which three statements are true about the interpretation of an execution plan? (Choose three.)
A. The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.
B. 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.
C. 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.
D. An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.
E. A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.
Answer: B,D,E
Q53. You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large tables.
Which three aspects should you consider before you choose this compression method? (Choose three.)
A. Check whether direct path load operations are used to insert rows in the table.
B. Check whether the table is frequently queried using full table scans as column store compression only minimizes I/O during full table scans.
C. Check whether the table is frequently updated because it will have overhead for insert and update operations.
D. Check whether the table has LOB columns as it will minimize I/O for the queries.
E. Check whether the table blocks are sparsely populated as this will defragment the blocks.
Answer: A,B,D
Q54. Examine the Load Profile section of an AWR report:
Which two inferences can you derive from the details in this section? (Choose two.)
A. The values for Redo size and Block changes imply that only updates were performed by transactions.
B. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
C. The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
D. The values for SQL Work Area and User calls imply that only sort-based operations were performed.
E. 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
Updated 1Z0-064 exam answers:
Q55. 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.)
A. creating a bitmap index on the COUNTRY_ID column
B. regathering statistics on the CUSTOMERS table
C. gathering statistics on the COUNTRY_IDX index
D. creating a histogram on the COUNTRY_ID column
E. increasing the size of the PGA
F. creating an SQL profile
G. creating a KEEP cache
Answer: A,D
Q56. Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events:
Identify three possible reasons for the increased response time. (Choose three.)
A. too many sort operations being performed
B. repeated simultaneous access to a block or small number of blocks
C. the shared pool is inadequately sized
D. queries not using indexes and performing full table scans
E. queries repeatedly fetching blocks that are not in the database buffer cache
F. cursors are closed explicitly after each execution
Answer: B,D,E
Q57. Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)
A. executing SQL statements in an SQL Tuning Set (STS) on a test database by using database links to the production database.
B. generating only execution plans on a test database without actually running SQL statements.
C. generating an execution plan and statistics for selective SQL statements captured in an STS
D. loading performance data and execution plans from an STS.
E. generating both execution plans and statistics for each SQL statement in an STS by actually running the SQL statements on a test database.
Answer: B,D,E
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_pre_change.htm#RATUG1 81
Q58. 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.)
A. Create an STS for the queries cached in the library cache and submit it as an input to SQL Tuning Advisor.
B. Create an STS for the queries cached in the library cache and submit it as an input to SQL Access Advisor.
C. Capture the workload in an STS and submit to SQL Tuning Advisor for recommendations.
D. Create an STS for the queries cached in the library cache and submit it as an input to SQL Performance Analyzer.
Answer: D