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

  • 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 #16
You need to create a package that automatically sends an alert to users in case the third step fails.
Which option represents the steps to accomplish this? (Choose the best answer.)
  1. A
    Add an OdiSendMail step to My Package and link the My Third Package step to it by using a green OK arrow.
  2. B
    Add an OdiSendMail step to My Package and link the My Last Package step to it by using a red KO arrow.
  3. C
    Add an OdiReadMail step to My Package and link the My Third Package step to it by using a red KO arrow.
  4. D
    Add an OdiSendMail step to My Package and link the My Third Package step to it by using a red KO arrow.

Correct Answer:
B
(https://gurcanorhan.wordpress.com/2012/11/30/odi-alert-mechanism/)

Question #17
Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)
  1. A
    Run Exception and Restart
  2. B
    Run Exception and Continue
  3. C
    Run Exception and Ignore
  4. D
    Run Exception and Fail
  5. E
    Run Exception and Raise

Correct Answer:
CE
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1350)

Question #18
Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)
  1. A
    ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.
  2. B
    It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.
  3. C
    It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.
  4. D
    It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

Correct Answer:
C
(http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/)

Question #19
You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error.
Why did this happen? (Choose the best answer.)
  1. A
    It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.
  2. B
    It is not possible to enforce constraints on any technology.
  3. C
    It is only possible to forward-engineer it to the flat file definition.
  4. D
    It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file.

Correct Answer:
D
(http://www.oracle.com/technetwork/middleware/data-integrator/learnmore/odi-best-practice-data-warehouse-168255.pdf)

Question #20
Which statement is correct about the tasks that Standalone Agents perform? (Choose the best answer.)
  1. A
    They update or modify code to be executed, check security, select database servers, and update log files after execution.
  2. B
    They schedule scenarios to be executed, check security, constraints and update log files after execution.
  3. C
    They retrieve code from the execution repository and request database servers, operating systems, or scripting engines for execution.
  4. D
    They schedule code from the execution repository and update log files after execution.

Correct Answer:
C
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12641/overview.htm#ODIGS423)

Previous Questions Next Questions

All Pages