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

  • 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 #16
Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B.
Which architecture would you suggest to solve this deployment issue?
  1. A
    Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.
  2. B
    Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.
  3. C
    Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.
  4. D
    Define the split by setting up database services that are specific to department A and department B.

Correct Answer:
D

Question #17
There are many different ways to load data into database tables.
Which method does Oracle strongly recommend?
  1. A
    generic connectivity via ODBC or JDBC
  2. B
    database gateways to open systems and mainframes
  3. C
    Oracle GoldenGate
  4. D
    Oracle Data Pump
  5. E
    SQL*Loader import
  6. F
    data loading via external tables

Correct Answer:
F

Question #18
Which options does not benefit from storage offload processing?
  1. A
    indexes that rely on B-Tree pointers
  2. B
    column filtering
  3. C
    joins and aggregation
  4. D
    table scans
  5. E
    incremental backups with block change tracking

Correct Answer:
A
Reference:
https://www.pythian.com/blog/exadata-join-offloading-in-action/

Question #19
Your customer would like to configure monitoring capabilities alongside ASR on the stand-alone server that was set aside to run ASR Manager.
What configuration would you set up for the customer?
  1. A
    Enterprise Manager, SQL Developer Server, and ASR Manager on the stand-alone server because ASR needs SQL Developer to gain SQL access to the database server
  2. B
    ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised
  3. C
    ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine
  4. D
    Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool

Correct Answer:
D

Question #20
Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)
  1. A
    Purchase the recommended x86 64-Bit gateway hardware from Oracle.
  2. B
    Install in Oracle Virtual Machine with required hardware.
  3. C
    Install on Exadata Engineered System.
  4. D
    Provide individual x86 64-Bit gateway hardware.
  5. E
    Install on Oracle Database Appliance.

Correct Answer:
ABC
Reference:
http://www.oracle.com/us/assets/platinum-services-faq-1653259.pdf

Previous Questions Next Questions

All Pages