Oracle 1Z0-448 Practice Questions| TestInsights

Question 1

Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)

AEvaluate Variable

BSet Variable

CDeclare Variable

DRefresh Variable

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AEvaluate Variable

BSet Variable

CDeclare Variable

DRefresh Variable

Question 2

You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)

AThis works only for Oracle and Informix.

BThis works only for Oracle and MySQL.

CCreate a new generic technology to support it.

DUse the out-ofthe box Generic SQL technology.

Correct : D

(https://docs.oracle.com/middleware/1212/odi/ODIDG/projects.htm#ODIDG326)

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AThis works only for Oracle and Informix.

BThis works only for Oracle and MySQL.

CCreate a new generic technology to support it.

DUse the out-ofthe box Generic SQL technology.

Question 3

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

AThe Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.

BThe Knowledge Module must be customized only for aggregation functions.

CThe Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

DThe Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Correct : D

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1625)

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AThe Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.

BThe Knowledge Module must be customized only for aggregation functions.

CThe Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

DThe Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Question 4

Which statement is correct about all expressions in a Mapping? (Choose the best answer.)

AIt is possible to set the execution location on source, staging area, or target.

BAll transformations are executed on the staging area.

COnly the source and target servers can be used to execute expressions.

DAll expressions are executed on the source area.

Correct : A

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1040)

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt is possible to set the execution location on source, staging area, or target.

BAll transformations are executed on the staging area.

COnly the source and target servers can be used to execute expressions.

DAll expressions are executed on the source area.

Question 5

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

AIt enables developers to execute most ODI operations through a Java program.

BIt can be used to embed ODI processes into another product.

CIt is used to load data between Teradata and Oracle.

DIt must be used by ETL developers to develop ODI processes.

Correct : A, D

(https://foursconsultancy.wordpress.com/odi/oracle-data-integrator-12ccomponents/)

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt enables developers to execute most ODI operations through a Java program.

BIt can be used to embed ODI processes into another product.

CIt is used to load data between Teradata and Oracle.

DIt must be used by ETL developers to develop ODI processes.

Curious about Actual Oracle Java (1Z0-448) Exam Questions?

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: