Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-064

Oracle 1z0-064 Exam Practice Questions (P. 1)

  • Full Access (84 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.
You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.
Which three objectives can be achieved by the Resource Manager? (Choose three.)
  1. A
    limiting the amount of time that a session is idle and blocking other sessions of the ERP application
  2. B
    limiting the amount of undo generated by operations performed by sessions created by the ERP application
  3. C
    creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload
  4. D
    allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application
  5. E
    limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

Correct Answer:
BDE

Question #2
Examine the partial TKPROF output for an SQL statement:

Which two inferences can definitely be made from this output? (Choose two.)
  1. A
    Array fetch operations were not performed for this query.
  2. B
    No hard parse was performed for this query.
  3. C
    The number of logical I/Os is almost equal to the number of physical I/Os.
  4. D
    Another transaction held a shared lock on the table, thereby causing a significant delay.

Correct Answer:
BD

Question #3
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.)
  1. A
    It generates an error because the warning threshold cannot exceed 100%.
  2. B
    It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.
  3. C
    It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.
  4. D
    It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.
  5. 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.

Correct Answer:
A

Question #4
You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.
How would you achieve this? (Choose the best answer.)
  1. A
    Create AWR baselines.
  2. B
    Create SQL plan baselines.
  3. C
    Create repeating baseline templates.
  4. D
    Create database services and make sure that user connections use them to connect to the database instance.
  5. E
    Create a single baseline template.

Correct Answer:
D

Question #5
Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)
  1. A
    setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
  2. B
    coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required
  3. C
    setting the CURSOR_SHARING parameter to EXACT
  4. D
    avoiding the granting of privileges on objects associated with cursors during peak load
  5. E
    enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE
  6. F
    configuring shared server connections

Correct Answer:
CE
Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm

Next Questions

All Pages