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

  • 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 #11
You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?
  1. A
    The incorrect version of GoldenGate was installed for your CPU architecture.
  2. B
    A license key must be applied first.
  3. C
    GoldenGate Manager was not started first.
  4. D
    The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set.

Correct Answer:
A

Question #12
Identify the correct statement regarding Trails.
  1. A
    Extract and Pump are different OS level executable binary files.
  2. B
    Extracts cannot perform filtering, mapping, and transformations.
  3. C
    RMTTRAIL is for remote trails and EXTTRAIL is for local trails.
  4. D
    Extract is typically used to produce local trail files over a TCP/IP connection.

Correct Answer:
B

Question #13
Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.
  1. A
    Run the chkpt_db_extracttrail.sql script.
  2. B
    Run the chkpt_db_create.sql script.
  3. C
    Use the ADD Extract Trail command.
  4. D
    Use the INFO REPLICAT command with the SHOWCH option.
  5. E
    Use the ADD CHECKPOINTTABLE command.

Correct Answer:
BE
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_ogg_checkpts.htm#GWUAD972

Question #14
You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-todatabase utility. How should you configure GoldenGate in order to accomplish this?
  1. A
    Configure Replicat with the FORMATASCII SQLLOADER OPTION.
  2. B
    Configure Extract with the FORMATSQL SQLLOADER OPTION.
  3. C
    Configure Extract with the FORMATASCII SQLLOADER OPTION.
  4. D
    Configure Replicat with the FORMATXML OPTION.

Correct Answer:
C
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_initsync.htm#GWUAD546

Question #15
Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after
Extract has stopped?
  1. A
    Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility.
  2. B
    Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
  3. C
    Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility.
  4. D
    Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility.

Correct Answer:
C
Reference:
http://www.oracle.com/technetwork/database/features/availability/maa-goldengate-rac-2007111.pdf

Previous Questions Next Questions

All Pages