Master the content and be ready for exam day success quickly with this . We guarantee it!We make it a reality and give you real in our Oracle 1Z0-064 braindumps. Latest 100% VALID at below page. You can use our Oracle 1Z0-064 braindumps and pass your exam.

Online Oracle 1Z0-064 free dumps demo Below:

NEW QUESTION 1
Examine the partial TKPROF output for an SQL statement:
1Z0-064 dumps exhibit
Which two inferences can definitely be made from this output? (Choose two.)

  • A. Array fetch operations were not performed for this query.
  • B. No hard parse was performed for this query.
  • C. The number of logical I/Os is almost equal to the number of physical I/Os.
  • D. Another transaction held a shared lock on the table, thereby causing a significant delay.

Answer: BD

NEW QUESTION 2
Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)

  • A. DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.
  • B. DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.
  • C. DB time includes the time spent on client processes and background processes.
  • D. Reducing DB time allows a database instance to support more user requests by using the same resources.
  • E. DB time is always greater than or equal to the DB CPU time.

Answer: DE

NEW QUESTION 3
You execute this query twice in a session:
1Z0-064 dumps exhibit
Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.
1Z0-064 dumps exhibit
Which two statements are true? (Choose two.)

  • A. No statistics were collected during the first execution of the query.
  • B. A subsequent execution of the query in this session is likely to undergo a soft parse.
  • C. The second execution of the query was hard parsed because the estimated cardinality was inaccurate.
  • D. A subsequent execution of the query in this session will undergo a hard parse.
  • E. The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query.

Answer: BC

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

  • A. It is automatically invoked whenever the AWR Compare Period report is invoked.
  • B. It is automatically invoked whenever ADDM is run by default.
  • C. 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.
  • D. It can be used to create a comparison report between the Database Replay workload capture report and the replay report.

Answer: CD

NEW QUESTION 5
Examine the parameters:
1Z0-064 dumps exhibit
Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and high number of direct path write wait events.
Which two actions could improve the performance? (Choose two.)

  • A. increasing the value of the SORT_AREA_SIZE parameter
  • B. increasing the value of the PGA_AGGREGATE_TARGET parameter
  • C. enabling Automatic Memory Management for the instance
  • D. increasing the size of the default temporary tablespace
  • E. using parallel hint in queries performing large sort operations
  • F. enabling Automatic Shared Memory Management for the instance

Answer: AF

NEW QUESTION 6
You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

  • A. Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.
  • B. Use the result cache hint in the queries.
  • C. Use bind variables for similar queries instead of literals.
  • D. Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.
  • E. Configure the KEEP pool and cache the queried tables used in the KEEP pool.

Answer: AB

NEW QUESTION 7
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.
1Z0-064 dumps exhibit
Which three options would improve the performance of the query? (Choose three.)

  • A. creating a bitmap index on the COUNTRY_ID column
  • B. regathering statistics on the CUSTOMERS table
  • C. creating a histogram on the COUNTRY_ID column
  • D. increasing the size of the PGA
  • E. creating an SQL profile
  • F. creating a KEEP cache

Answer: ABF

NEW QUESTION 8
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.
1Z0-064 dumps exhibit
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: AD

NEW QUESTION 9
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.)

  • A. Alerts are recorded in both Oracle Enterprise Manager Cloud Control and DBA_OUTSTANDING_ALERTS only when the critical threshold is exceeded.
  • B. Alert settings for the warning and critical levels must be disabled before taking the USERS tablespace offline.
  • C. Alerts that are triggered are automatically recorded in DBA_ALERT_HISTORY after they are cleared.
  • D. Alerts are triggered when the space usage reaches the warning level, again when it reaches the critical level, and yet again when the space usage falls below the critical level.

Answer: BC

NEW QUESTION 10
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: BDE

Explanation: Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_pre_change.htm#RATUG1 81

NEW QUESTION 11
Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)

  • A. distributing available CPU by allocating percentages of CPU time to different users and applications
  • B. limiting the degree of parallelism of any operation performed by members of a group of users
  • C. limiting queries based on resource consumption of runaway sessions or calls that consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time
  • D. limiting the number of concurrent sessions for a user
  • E. limiting the number of user sessions allowed to be concurrently active within a group of users
  • F. limiting the number of parallel executions that can be executed by a user

Answer: ABCE

NEW QUESTION 12
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.)

  • A. gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics
  • B. using SQL plan directives to generate an optimal plan
  • C. setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true
  • D. creating column group statistics, regathering statistics, and ensuring that histograms exist on both these columns

Answer: AD

NEW QUESTION 13
Examine the command to change a parameter value from the default to 50: SQL> ALTER SYSTEM SET OPTIMIZER_INDEX_COST_ADJ = 50;
What is the effect of changing the value of the parameter? (Choose the best answer.)

  • A. It influences the optimizer to use full table scans instead of index scans as the estimated cost of full table scan is reduced.
  • B. It influences the optimizer to use bitmap indexes as the estimated cost of conversion from bitmap to rowid is reduced.
  • C. It influences the optimizer to always use fast full index scans as the estimated cost of using an index is reduced.
  • D. It influences the optimizer to use indexes instead of full table scans as the estimated cost of using an index is reduced.

Answer: A

Explanation: Reference: http://www.dba-oracle.com/oracle_tips_cost_adj.htm

NEW QUESTION 14
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 pool wait events and also a high percentage of the hard parse elapsed time.
Which two can be reasons for this? (Choose two.)

  • A. The I/O performance is slow.
  • B. Bind variables are not used for similar queries, causing hard parses.
  • C. Repeated access to a small number of blocks.
  • D. Excessive time is spent on finding cached cursors in the library cache.
  • E. The CURSOR_SHARING parameter is set to EXACT, which does not allow similar queries to share a cursor.

Answer: BC

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

  • A. when the sampling time is a small fraction of the total time for a query
  • B. when an execution plan is suboptimal because of complex predicates
  • C. when extended statistics are not available for SQL statements that use complex predicates
  • D. when a query is on a partitioned table with a global index
  • E. when index statistics are missing on a column that is used in SQL statements with highly selective filters

Answer: ABC

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

NEW QUESTION 16
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: BDE

NEW QUESTION 17
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.)

  • A. Increase the size of the undo tablespace and enable undo retention guarantee.
  • B. Increase the size of the database buffer cache.
  • C. Enable temporary undo.
  • D. Increase the size of the temporary tablespace or make it autoextensible.
  • E. Enable Automatic Segment Space Management (ASSM) for the undo tablespace.

Answer: C

Explanation: Reference: https://docs.oracle.com/cd/B13789_01/server.101/b10739/undo.htm

NEW QUESTION 18
Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:
1Z0-064 dumps exhibit
What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)

  • A. the V$ACTIVE_SESSION_HISTORY view
  • B. the Time Model Statistics section of the AWR report
  • C. the SQL statements based on elapsed time from the AWR report
  • D. the Latch Activity section
  • E. the Segment Statistics section of the AWR report

Answer: B

Recommend!! Get the Full 1Z0-064 dumps in VCE and PDF From Surepassexam, Welcome to Download: https://www.surepassexam.com/1Z0-064-exam-dumps.html (New 84 Q&As Version)