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

  • 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 #21
Which two statements are true about metrics in the DBMCLI utility? (Choose two.)
  1. A
    Metric values are computed and stored in memory, and then permanently stored on disk.
  2. B
    DBMCLI can be used to report on Exadata storage server metrics.
  3. C
    Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.
  4. D
    Fields in AlertHistory cannot be modified.
  5. E
    DBMCLI reported metrics are informational only and cannot be used to trigger alerts or reported events.

Correct Answer:
AC
Reference:
https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/app_dbmcli.htm#DBMMN22246

Question #22
What happens in an Exadata Database Machine when the DUPLICATE sub-clause of the INMEMORY attribute is specified?
  1. A
    The DUPLICATE sub-clause enables parallel execution NUMA support.
  2. B
    Each In-Memory Compression Unit in the IM column store will have a mirrored copy placed on another node in the RAC cluster.
  3. C
    The command allows the current instance to exceed DRAM limits and expand across memory, flash, and disk.
  4. D
    The command creates an in-memory snapshot for write_only access.
  5. E
    The In-Memory Compression Unit will have a mirrored copy placed on every other node in the RAC cluster.

Correct Answer:
B
Reference:
http://www.oracle.com/technetwork/database/in-memory/learnmore/twp-dbim-exadata-2556211.pdf
(page 3)

Question #23
Which statement explains the difference between Normal and High redundancy ASM failure groups?
  1. A
    Normal redundancy protects the DATA diskgroup, whereas High redundancy protects the RECO diskgroup.
  2. B
    Normal redundancy (best practice) provides protection against two simultaneous disk failures, whereas High redundancy provides protection against a single disk failure or an entire storage server failure.
  3. C
    High redundancy gives more usable storage, whereas Normal redundancy provides better I/O performance.
  4. D
    Normal redundancy protects from disk failure when a cell is offline or being updated, whereas High redundancy protects the system when all the cells are offline.
  5. E
    Normal redundancy tolerates a single cell failure, whereas High redundancy tolerates a two-cell failure.

Correct Answer:
E
Reference:
http://blog.umairmansoob.com/tag/using-high-vs-normal-redundancy-in-exadata/

Question #24
You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes.
Which two statements are true? (Choose two.)

  1. A
    The accumulated I/O saved by the storage index is 1.68 MB.
  2. B
    The storage indexes reduced the amount of physical I/O bytes significantly for this query.
  3. C
    Since the database was started, no queries were run against this table with the same predicate.
  4. D
    The storage index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
  5. E
    The storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.

Correct Answer:
BD

Question #25
When backing up a storage cell, what is actually being backed up?
  1. A
    the first two disks in a storage cell that contain the Linux operating system
  2. B
    all the disk headers and storage indexes in the storage cell
  3. C
    the contents of the CELLBOT USB flash drive
  4. D
    the Linux RPM that is used to deploy the storage cell software

Correct Answer:
B

Previous Questions Next Questions

All Pages