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

  • 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 #1
What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?
  1. A
    You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.
  2. B
    After a SQL Profile is created, it will then run efficiently for the life of the database.
  3. C
    The SQL Profile rewrites the SQL Statement issued by the application so it appears to the Optimizer as a perfectly written SQL statement.
  4. D
    You can have only one SQL Profile active at one time for a single SQL statement.
  5. E
    You need Oracle Database 12c or later to use SQL Profiles.
  6. F
    SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack is licensed.

Correct Answer:
AD

Question #2
A customer has database performance issues within their Oracle Real Application Cluster. What is the next step?
  1. A
    Run the V$RAC script to dump all the RAC statistics and look for what has the highest metric accumulation.
  2. B
    Use the application load testing utility to overload a copy of their application in development to flush out the issue.
  3. C
    Turnoff RAC interconnects to isolate any network issues impacting database performance problems.
  4. D
    Use a third-party RAC tool to identify the bad SQL and then rewrite it.
  5. E
    Utilize the Oracle Database Performance Method to help identify and correct issue.

Correct Answer:
E

Question #3
For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?
  1. A
    to determine if objects have unused space that can be released
  2. B
    to advise if materialized views can be used to reduce size of views
  3. C
    to review space usage of individual schema objects or tablespaces
  4. D
    to advise if there are any duplicate indexes and automate their removal
  5. E
    to identify any fragmentation in the database cache or swap space

Correct Answer:
AC

Question #4
What are three activities an Oracle Database Performance and Tuning solution enables a customer to perform?
  1. A
    standardize database troubleshooting and diagnostics
  2. B
    control database clouds.
  3. C
    automate database performance management
  4. D
    perform global database backup
  5. E
    outsource database operations
  6. F
    replay and test actual workloads to assure database performance and consolidatios.

Correct Answer:
CDE

Question #5
Which two would automatically create an entry in V$SQL_MONITOR?
  1. A
    a parallelized SQL statement
  2. B
    any SQL statement run
  3. C
    any DML statement
  4. D
    a statement that consumes at least 1 second of CPU or I/O time.
  5. E
    a statement that consumes at least 5 second of CPU or I/O time.
  6. F
    any DDL statement

Correct Answer:
CF
Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL789

Next Questions

All Pages