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

Oracle 1z0-447 Exam Practice Questions (P. 2)

  • 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 #6
You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?
  1. A
    It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
  2. B
    It is caused by the thread with the highest thread ID applying barrier transactions.
  3. C
    It is caused by the use of the MAXTRANSOPS parameter.
  4. D
    It is caused by barrier transactions in a Coordinated Replicat.

Correct Answer:
D
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_changesync.htm#GWUAD953

Question #7
Your Goldengate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version.
How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key?
  1. A
    GoldenGate deployments cannot use a shared wallet.
  2. B
    View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by all Replicat groups.
  3. C
    View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.
  4. D
    View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the

Correct Answer:
D
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ggsci_commands042.htm#GWURF945
(see note)

Question #8
What is the function of the GoldenGate JAgent?
  1. A
    It performs connections via JDBC to run the Veridata comparisons.
  2. B
    It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent.
  3. C
    It reads the database transaction logs.
  4. D
    It integrates GoldenGate with Oracle Data Integrator.

Correct Answer:
B

Question #9
What software is required prior to running Oracle GoldenGate in a Windows Server environment?
  1. A
    Oracle Gateway software configured for that particular database platform
  2. B
    JDBC drivers into the GoldenGate home directory
  3. C
    Microsoft Visual C++ 2010 SP1 Redistributable Package
  4. D
    Nothing, configure GoldenGate Jagent for that particular database platform.

Correct Answer:
C
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GIMSS/system_requirements.htm#GIMSS182

Question #10
Which statement is valid for DDL replication?
  1. A
    GoldenGate User Exits are not supported for DDL.
  2. B
    Source and target objects can be different.
  3. C
    Target objects can be different from source when using SOURCEDEFS in Replicat.
  4. D
    It can use WILDCARDRESOLVE IMMEDIATE.

Correct Answer:
B

Previous Questions Next Questions

All Pages