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

  • 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 #16
What are three reasons an implementation of an Oracle Database Performance and Tuning solution is superior to that of scripts or third-party tools?
  1. A
    It is a part of the database, which means no added installations, configurations, extra user accounts, privilege granting, etc.
  2. B
    It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch or database upgrade.
  3. C
    It has the largest library of custom scripts and procedures and includes an assembly builder to maintain them and add more.
  4. D
    Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what the optimizer may do.
  5. E
    It is the most inexpensive tool in the market.

Correct Answer:
BDE

Question #17
To use Automatic Database Diagnostic Management capability on a database using a SQL script, command line, database views, or from a GUI, which option needs to be licensed?
  1. A
    Oracle Diagnostics Pack for Oracle Databases
  2. B
    Oracle Tuning Pack for Oracle Databases
  3. C
    Oracle Diagnostics and Tuning Pack for Oracle Databases
  4. D
    Oracle ADDM Pack
  5. E
    Nothing else needs to be licensed.

Correct Answer:
C

Question #18
When planning Oracle Database Architecture, which option can be used to reduce the number of Oracle processes waiting in the Operating System run queue and to ensure that database CPU load is healthy?
  1. A
    Exadata
  2. B
    Oracle Job Scheduler
  3. C
    DATABASE_MAXCPUS=YES
  4. D
    Oracle Database Resource Manager
  5. E
    DB_RAC_MAXCPU=YES
  6. F
    Oracle Grid Control

Correct Answer:
D
Reference: http://www.oracle.com/technetwork/database/performance/resource-manager-twp-133705.pdf

Question #19
You need to limit the resources available to each Pluggable Database (PDB) within a Container Database (CDB). Utilizing Resource Manager, which are three options that can be managed by a resource plan?
  1. A
    memory
  2. B
    CPU
  3. C
    Parallel Execution Servers
  4. D
    shares of system resources
  5. E
    number of users
  6. F
    number of tables or indexes
  7. G
    number of indexes

Correct Answer:
BCD

Question #20
Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?
  1. A
    Use smaller database block size.
  2. B
    Use larger database block size.
  3. C
    Use direct-path inserts where possible.
  4. D
    Increase PCTFREE on the table segment.
  5. E
    Increase the size of the tablespace.

Correct Answer:
AE

Previous Questions Next Questions

All Pages