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

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

  • Full Access (81 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
Your customer is implementing a storage consolidation strategy on their existing Exadata.
Which step represents the Oracle recommended action that the customer should take in their approach?
  1. A
    Do not use IORM because it will interfere with the shared database functionality on Exadata.
  2. B
    Use ASM to create separate diskgroups for each database instance that is running on Exadata.
  3. C
    Use IORM to distribute disk bandwidth among the databases.
  4. D
    Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
  5. E
    Set up a resource consumer group within each database instance and manage it individually.

Correct Answer:
C
Reference:
http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata-300345.pdf page 42

Question #12
How does Advanced Compression differ from Hybrid Columnar Compression?
  1. A
    Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.
  2. B
    They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.
  3. C
    Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.
  4. D
    Advanced Compression is good for tables with active updates and deletes, whereas Hybrid Columnar Compression is best applied to tables or partitions where

Correct Answer:
D

Question #13
The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-imaged with an Oracle Support installation image.
Which three tasks must be performed in order to re-image the compute node? (Choose three.)
  1. A
    Create a CELLBOOT USB Flash Drive by using an external USB drive.
  2. B
    Mount the LVM backup image across the network and recover the system.
  3. C
    Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
  4. D
    Reboot the new server by using a bootable recovery image from the external USB drive.
  5. E
    Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

Correct Answer:
CDE

Question #14
Which statement is true about instance caging setup?
  1. A
    The initialization parameter resource_manager_plan should be set.
  2. B
    For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing.
  3. C
    Database instances need to be restarted to make changes to cpu_count effective.
  4. D
    The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
  5. E
    Instance caging is the right approach to make sure that database instances are not stealin memory from one another.

Correct Answer:
A
Reference:
http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf

Question #15
Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete ACFS filesystems? (Choose three.)
  1. A
    SQL*Plus and ASMCMD
  2. B
    ASMCA
  3. C
    Enterprise Manager Express
  4. D
    Enterprise Manager Cloud Control
  5. E
    RMAN
  6. F
    OUI

Correct Answer:
ABC
Reference -
https://dbasolutions.wikispaces.com/ACFS+on+Linux

Previous Questions Next Questions

All Pages