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

  • 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 #11
You have configured and added the extract and Replicate tasks using the direct load method what do you need to do to get the processes up and running?
  1. A
    Start the Extract task.
  2. B
    Start the Extract task and then start the Replicat task.
  3. C
    Start the Extract task; wait for it to stop and than start the Replicate task.
  4. D
    Start the Replicate task

Correct Answer:
A
In reference guide, page 279, "Use the RMTTASK parameter for an initial-load Extract to initiate a Replicat processing task during a GoldenGate direct load or a direct bulk load to SQL*Loader. RMTTASK directs Extract to communicate directly with Replicat over TCP/IP and bypasses the use of aCollector process or disk storage. RMTTASK also directs Extract to request that Managerstart Replicat automatically, and then stop Replicat when the run is finished. "

Question #12
You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can you treat these as identical tables?
  1. A
    No
  2. B
    Yes, if the source and target Oracle versions and character sets are the same.
  3. C
    Yes
  4. D
    Yes, as long as the source table has a primary key define

Correct Answer:
A
In reference guide, page 119, when replicating from identical sources to targets, the param ASSUMETARGETDEFS must be used, and the only with being with columns in different orders, the answer is NO

Question #13
What us expected behavior of CHEKPARMS parameter?
  1. A
    The process checks the parameter syntax and then starts running.
  2. B
    The process checks the parameter syntax and then stops.
  3. C
    A report file is created listing all missing parameters.
  4. D
    A report file is created listing all default values not specified in the parameter file.

Correct Answer:
B
In reference guide, page 131, and I quote "Without processing data, GoldenGate audits the syntax and connects to the database to verify that listed tables exist. If there is a syntax failure, the process abends with GoldenGate error 190. If the syntax succeeds, the process stops and writes a message to the report file that the parameters processed successfully."

Question #14
What GoldenGate facility allows for custom processing in response to a data value?
  1. A
    DDLGEN
  2. B
    GGSExec
  3. C
    User Exits
  4. D
    User Tokens

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

Question #15
How do you control the size of the buffer that contains data extracted from an ASM instance?
  1. A
    TRANLOGOPTIONS ASMBUFSIZ
  2. B
    DBOPTIONS ASMBUFSIZE
  3. C
    TRANLOGOPTIONS BUFSIZE
  4. D
    DBOPTIONS BUFSIZE

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

Previous Questions Next Questions

All Pages