1Z0-064 | The Abreast of the times Guide To 1Z0-064 examcollection
Q1. 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
Q2. 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: D,E
Q3. Examine the query and its output:
Which two inferences can be definitely derived from this output? (Choose two.)
A. The db file scattered read event has occurred 104 times in this session for file# 12.
B. The session has completed performing a full table scan.
C. The SQL statements in this session are performing excessive disk reads.
D. The multiblock factor is 8 for this I/O but it could vary for the other I/O events.
Answer: A,C
Q4. 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.)
A. Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
B. Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
C. Set the threshold for UNDO tablespace usage for the users.
D. Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.
Answer: D
Q5. 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.)
A. It generates an error because the warning threshold cannot exceed 100%.
B. It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.
C. It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.
D. It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.
E. It generates an alert when 1 in 100 observations for an observed metric exceeds the 99th percentile value as measured over the fixed baseline.
Answer: A
Q6. 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.)
A. Create a histogram on the DEPARTMENT_ID column.
B. Change the default CURSOR_SHARING value to FORCE.
C. Execute the query with the same DEPARTMENT_ID value multiple times.
D. Create an index on the DEPARTMENT_ID column.
E. Gather statistics for the index.
F. Regather statistics on the table.
Answer: C,D
Q7. Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)
A. A high value indicates that the buffer cache is adequately sized for the current workload.
B. Poor hit ratios indicate that a large number of indexed lookups or small table scans are being performed.
C. A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve performance.
D. A high hit ratio may indicate that repeated scanning of the same large table or index is being performed.
E. A low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object accessed in the buffer cache.
Answer: C,D
Q8. 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.)
A. Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE attribute.
B. Create it in a locally managed tablespace with manual segment space management.
C. Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.
D. Create it in locally managed tablespace with ASSM enabled and an additional freelist.
Answer: C
Q9. 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: B,C
Q10. 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
Answer: E