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. 3)

  • 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 #11
Examine the Time Model Statistics section of an AWR report:

Which two inferences can be definitely derived from this section? (Choose two.)
  1. A
    The available CPU resources were not utilized to their maximum capacity.
  2. B
    All sequence numbers used during this AWR time interval were cached.
  3. C
    A large number of connected user sessions were idle.
  4. D
    New child cursors were created because of new bind values or usage of literal values as well as different bind types or sizes.
  5. E
    The DB CPU time was not spent exclusively for processing SQL statements.

Correct Answer:
DE

Question #12
Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:

What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)
  1. A
    the V$ACTIVE_SESSION_HISTORY view
  2. B
    the Time Model Statistics section of the AWR report
  3. C
    the SQL statements based on elapsed time from the AWR report
  4. D
    the Latch Activity section
  5. E
    the Segment Statistics section of the AWR report

Correct Answer:
B

Question #13
Examine the partial AWR report taken for a time period of 60 minutes:

Which two inferences can you draw from this report? (Choose two.)
  1. A
    The database user calls are issuing frequent explicit commits.
  2. B
    The CPUs are busy executing server processes and background processes for a considerable amount of CPU time.
  3. C
    The database user calls are spending most of their time in I/O for single block reads.
  4. D
    The database user calls are spending most of their time waiting for sessions that are in more important consumer groups.

Correct Answer:
BC

Question #14
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.)
  1. A
    Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
  2. B
    Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
  3. C
    Set the threshold for UNDO tablespace usage for the users.
  4. D
    Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.

Correct Answer:
D

Question #15
Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
  1. A
    Use the Resource Manager.
  2. B
    Enable SQL Trace at the session level.
  3. C
    Create a service.
  4. D
    Use a dedicated server configuration.
  5. E
    Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.

Correct Answer:
AB

Previous Questions Next Questions

All Pages