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

Oracle 1z0-481 Exam Practice Questions (P. 5)

  • Full Access (79 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
To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANSOPS what is the most important thing Carlos should consider before using MAXTRANSOPS
  1. A
    Will business logic be lost if transaction boundaries are changed?
  2. B
    Will a large number of small commits perform better than a smaller number of large commits?
  3. C
    Will redo buffer size on the target database be adequate for the commit size?
  4. D
    Will the sequence of operations be affected by changing transaction boundaries?

Correct Answer:
D
In reference guide, page 238: "Limitations of useYou should have a valid business case for using MAXTRANSOPS other than simply for thepurpose of expediency. To use MAXTRANSOPS is to alter the transactional integrity that isimposed by the boundaries that are defined by the source application, even though Replicatapplies the operations in the correct order."

Question #22
In GoldenGate terms, what is the definition of Extract lag?
  1. A
    The difference in time between when a change is made to source data and when that change is reflected in the target data.
  2. B
    The difference in time between the current times at the target system.
  3. C
    The difference in time between when a change record is received at the target system and when the change is reflected in the target data.
  4. D
    The difference in time between when a change record is processed by the extract and the timestamp of the record in the data source.

Correct Answer:
D
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

Question #23
Which OGG process (es) can change data in database?
  1. A
    Replicat only
  2. B
    Extract only
  3. C
    Extract and Replicat
  4. D
    Extract, Replicat and Manager

Correct Answer:
C
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

Question #24
You have a source installation of OGG l0 that includes an initial extract and datapump to provide a remote trail formatted for a GoldenGate 9.5 Replicat process to consume, which process should be use to convert the data to the earlier format?
  1. A
    From the first Extract process
  2. B
    From the Data Pump process
  3. C
    From replicate process
  4. D
    This feature is not supported in GoldenGate 10.

Correct Answer:
A
References:

Question #25
You are responsible for replication between your central office and twelve regional nodes. What is the best product for you to use to actively monitor thirteen
GoldenGate TDM instances and configure email alerts based on process status?
  1. A
    Oracle GoldenGate Director
  2. B
    Oracle GoldenGate Transactional Data Management
  3. C
    Oracle GoldenGate veridata
  4. D
    Oracle GoldenGate Monitor

Correct Answer:
A
Oracle GoldenGate Director is the only tool for the job.
Incorrect answer:
There isn't a GoldenGate Monitor application

Previous Questions Next Questions

All Pages