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

  • 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 #21
, a customer asked that monitoring at an individual database level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise.
Which are two actions you would take to meet the customer's requirements?
  1. A
    Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.
  2. B
    For the always active Oracle Enterprise Manager Database Express process, create a script that will disable that process upon database boot.
  3. C
    Using the appropriate architecture implement Oracle Enterprise Manager.
  4. D
    Delete the "express" directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
  5. E
    Changes permissions of the "express" directory to real only by root.
  6. F
    Enable SNMP and configure MIBS on each database and forward database monitoring SNMP traps.

Correct Answer:
BE

Question #22
Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?
  1. A
    SQL Hints
  2. B
    Stored Outlines
  3. C
    Stored Profiles
  4. D
    SQL Plan Management
  5. E
    SQL Profiles

Correct Answer:
B
SQL statement, or migrate an existing stored outline by loading the "outlined" plan as a fixed plan.
Reference: https://docs.oracle.com/cd/E18283_01/server.112/e16638/optplanmgmt.htm

Question #23
When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?
  1. A
    Result Cache
  2. B
    Mega Cache
  3. C
    Oracle In-Memory Database Cache
  4. D
    Database Smart Flash Cache
  5. E
    Oracle In-Memory DBSTATS Cache

Correct Answer:
ACD

Question #24
Which option would you use to capture workloads from one or more systems concurrently and then play them back?
  1. A
    Automatic Workload Repository
  2. B
    Enterprise Manager Cloud Control
  3. C
    Consolidated Database Replay
  4. D
    Consolidation Planner
  5. E
    Workload Consolidator and Playback

Correct Answer:
C

Question #25
Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture?
  1. A
    Oracle Diagnostic Pack for Database
  2. B
    Real Application Testing
  3. C
    Oracle Migration Pack for Databases
  4. D
    Oracle Migration Performance Advisor
  5. E
    SQL Performance Testing Suite

Correct Answer:
C

Previous Questions Next Questions

All Pages