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

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

  • 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 #6
How are the ODI repositories upgraded? (Choose the best answer.)
  1. A
    by using Opatch
  2. B
    by using ODI Studio
  3. C
    by using the import/export utilities
  4. D
    by using Upgrade Assistant

Correct Answer:
A
(http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html)

Question #7
You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.)
  1. A
    Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
  2. B
    Use variables in the Logical Design of the Mapping to create unique temporary object names.
  3. C
    Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
  4. D
    Select the Use Unique Temporary Object Names check box at the Physical Design level.

Correct Answer:
D
(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)

Question #8
Which tables created by ODI contain error records? (Choose the best answer.)
  1. A
    ERR$
  2. B
    ERROR$
  3. C
    ODI_ERR$
  4. D
    E$

Correct Answer:
D
(https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925)

Question #9
Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality.
How can you achieve this? (Choose the best answer.)
  1. A
    The project must be explicitly mapped within an ODI mapping.
  2. B
    A customize knowledge module is needed.
  3. C
    An ODI procedure must be associated with it.
  4. D
    It can be defined for every technology listed in the topology.

Correct Answer:
D
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464)

Question #10
If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK.
What happens at run time when a Mapping gets executed? (Choose the best answer.)
  1. A
    All distinct entries are processed.
  2. B
    Only the latest entry is processed based on the JRN_DATE field.
  3. C
    Only the first entry is processed based on the JRN_DATE field.
  4. D
    A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.

Correct Answer:
B
(http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-with-oracle-goldengate/)

Previous Questions Next Questions

All Pages