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-417

Oracle 1z0-417 Exam Practice Questions (P. 3)

  • Full Access (82 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
At the IT Manager request, you are reviewing the databases that the DBA has implemented. You find STATISTICS_LEVEL configured as BASIC. What finding do you report back to the IT Manager?
  1. A
    The configuration of their databases is set up to also provide timed Operating System statistics and plan execution statistics.
  2. B
    The configuration of their databases is incorrect and should be set to NOT_TYPICAL.
  3. C
    The configuration of their databases has disabled collection of important statistics required for Oracle Database functionality.
  4. D
    The configuration of their databases needs to be set to ALL to enable collection of Operating System, Middleware, and storage statistics.

Correct Answer:
C

Question #12
Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?
  1. A
    LGWR
  2. B
    DBWR
  3. C
    CKPT
  4. D
    MMON
  5. E
    MMNL

Correct Answer:
D
The manageability monitor process (MMON) performs many tasks related to the
Automatic Workload Repository (AWR)
. For example, MMON
writes when a metric violates its threshold value, taking snapshots, and capturing statistics value for recently modified SQL objects.
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT008

Question #13
When preparing a new database installation, you want to ensure automatic collection of timed statistics. Which three configuration parameters are applicable?
  1. A
    STATISTICS_LEVEL parameter set to TYPICAL
  2. B
    STATISTICS_LEVEL parameter set to All
  3. C
    TIMED_STATISTICS parameter set to true
  4. D
    ALL_TIMED_STATISTICS parameter set to TRUE
  5. E
    AUTO_STATS parameter set to TRUE
  6. F
    STATISTICS_LEVEL parameter set to BASIC.

Correct Answer:
ABC

Question #14
Which is a capability that Active Session History (ASH) reports enable you to perform?
  1. A
    Compare database performance between two periods of time, and resolve performance degradation that may happen from one time period to another.
  2. B
    Analyze transient performance problems with the database that are short-lived and do not appear in the ADDM analysis.
  3. C
    Optimize the performance of data access paths by creating the proper set of materialized views, materialized view logs, and indexes for a given workload.
  4. D
    Analyze transient performance problems that have happened in the database since it has been started.

Correct Answer:
B
The Active Session History (ASH) reports enable you to analyze transient performance problems with the database that are short-lived and do not appear in the ADDM analysis.
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b28051/tdppt_method.htm#TDPPT017

Question #15
Multitenant option?
  1. A
    CPU
  2. B
    concurrent sessions
  3. C
    SGA
  4. D
    network I/O
  5. E
    ability to use parallel server processes
  6. F
    use of SGA memory and ability to allocate PGA

Correct Answer:
ABE

Previous Questions Next Questions

All Pages