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. 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
You need to look up table definitions in a file. Which Replicat parameter should you use?
  1. A
    ASSUMETARGETDEFS
  2. B
    COLMATCH
  3. C
    SOURCEDEFS
  4. D
    MAP

Correct Answer:
C

Question #22
You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?
  1. A
    You can configure integrated Replicat with two parallel apply servers.
  2. B
    You can configure integrated Replicat with two parallel child servers.
  3. C
    You can configure integrated Replicat with the SPECIALRUN parameter.
  4. D
    You can configure integrated Replicat with ASSUMETARGETDEFS and SPECIALRUN parameters.

Correct Answer:
A
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/process_mode.htm#GIORA219

Question #23
Which statement regarding the GoldenGate Data Pump is incorrect?
  1. A
    Data Pump is a separate process.
  2. B
    Data Pump can be used to pump trail records to multiple locations.
  3. C
    Data Pump has distance limitations.
  4. D
    Data Pump uses TCP/IP to route the trail records.

Correct Answer:
A

Question #24
Identify two correct statements regarding GoldenGate supported features.
  1. A
    GoldenGate supports network encryption and compression.
  2. B
    GoldenGate supports DML and DDL replication for all supported databases.
  3. C
    GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.
  4. D
    GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

Correct Answer:
clause.AC

Question #25
You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.
How should you accomplish this?
  1. A
    Use the COMPCOLS with the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.
  2. B
    Use the COMPARECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE
  3. C
    Use the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.
  4. D
    Use the GETBEFORECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat clause. WHERE

Correct Answer:
B
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/conflict_resolution.htm#GWUAD317

Previous Questions Next Questions

All Pages