1Z0-064 PDF DOWNLOAD

How to use our free PDF

Our Free PDF is based on the full mock exams which is available on our Web Site. The PDF consists in an extract of questions and answers with detailed explanations that are available to be:

On-Line Users: {{voteInfo.result.viewUsers}}
Subscribed Users: {{voteInfo.result.subscribedUsers}}
Thank you for your vote {{voteInfo.result.stars}} Your vote has already been submitted ({{voteInfo.result.votingPeople}} votes)

Follow us on SlideShare to see the latest available 1Z0-064 tests pdf.

Watch us also on Vimeo: See how our 1Z0-064 tests works.

									
										
										
Q1.To investigate the slow response time of queries on the TRANS table, you gathered the table
statistics and executed the query:
SQL> SELECT chain_cnt, round(chain_cnt/num_rows*100,2) pct_chained,avg_row_len,
pct_free, ct_used
FROM user_tables
WHERE table_name = 'TRANS';
CHAIN_CNT PCT_CHAINED AVG_ROW_LEN PCT_FREE PCT_USED
--------- ----------- ------------ -------- ---------
4789 100 3691 10 40
The table is stored in a tablespace that has Automatic Segment Space Management (ASSM) enabled. The
tablespace is created with a standard block size of 8192 bytes.
Which three can be reasons for the slow response time of the queries? (Choose three.)
A. Row size is too large to fit into a single block during insert operations.
B. Row moves from one data block to another data block because the row grows too large to fit in the
original block.
C. The table is subject to frequent insert, update, and delete DML activity leading to sparsely
populated blocks.
D. The value of PCTUSED is set to a value lower than the default, causing row changing.
E. The value of PCTFREE is set to a value lower than the default, causing row chaining.
Option A,B,C are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q2. 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
Option A,D are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q3. You want to capture the performance of your database during the last ten days of the first quarter
of the current financial year, so that you can compare this performance against the remaining quarter
ends of the current financial year.
Which method should you use? (Choose the best answer.)
https://www.certification-questions.com/
A. Create a static baseline that can be used with AWR compare reports.
B. Create a new moving window baseline and enable adaptive thresholds for relevant metrics.
C. Use a repeating baseline template to create and drop baselines based on a repeating time schedule
and set adaptive thresholds at a high significance level.
D. Use fixed baseline templates to create a new moving window baseline and set relevant warning alerts
that are computed as a percentage multiple of the maximum value observed for the data in the moving
window baseline.
Option D is correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com



Q4. You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is
set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you
find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits
in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the
AWR report:
Instance Efficiency Percentages (Target 100%)
----------------------------------------------------------------------------
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.95 In-memory Sort %: 100.00
Library Hit %: 62.17 Soft Parse %: 52.72
Execute to Parse %: 47.12 Latch Hit %: 97.95
Parse CPU to Parse Elapsed %: 53.98 % Non-Parse CPU: 70.94
Which three statements are true in this scenario? (Choose three.)
A. Sessions are waiting for mutexes in share mode on cursors but other sessions are holding the
mutexes in exclusive mode.
B. The CPU is spending more time in finding cursors in the library cache.
C. Cursors are not getting shared, resulting in a large number of hard parses.
D. Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the
mutexes in share mode.
E. The buffers required by queries are not found in the buffer cache, thereby increasing expensive
disk I/O.
Option B,D,E are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q5. 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
Option B,D,E are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com

Q6. Which two statements are true about gathering statistics? (Choose two.)
A. If an application has only SQL statements with bind variables, it is better to drop existing
histograms, disable creation of histograms, and allow the optimizer to select the best execution
plans.
B. If end users query newly inserted data, it is possible to get a suboptimal execution plan even if
the automatic statistics gathering job is enabled.
C. If concurrent statistics gathering is done by using parallel execution, the Resource Manager should
be used for efficient resource management.
https://www.certification-questions.com/
D. For each session that is accessing a global temporary table, the optimizer uses only the shared
statistics.
Option A,B are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com

Q7. 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.
Option B,D,E are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q8. Your database supports an OLTP workload during the day and batch processing at night. You want to
monitor performance metrics to detect any degradation of performance in both types of workloads over a
time period of 30 days.
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level
threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a
percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)
A. 5, 7
B. 2, 4, 3
C. 3, 4, 8
D. 4, 5, 7
E. 5, 1, 6, 8
Option E is correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q9. 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.)
A. Database Replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. Automatic Database Diagnostic Monitor (ADDM) compare periods report
E. SQL Performance Analyzer
https://www.certification-questions.com/
F. Automatic Workload Repository (AWR) compare periods report
Option B,E are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q10. 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
Option A,B,C are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com
Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341