Oracle 1Z0-482 Online Practice Questions and Exam Preparation

Oracle 1Z0-482 Online Questions & Answers

• Question 1:

  Identify the database view ODI uses when loading the journalized data in an Interface.

  A. JV$D view
  B. T$ view
  C. JV$ view
  D. JV$I view
  C. JV$ view

  ---

  Reference: http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/data_capture.htm#CFHFHIAJ

• Question 2:

  You want to add a new CDC subscriber in ODI after you have started the Journal process, what steps do you need to go through in order to use this new subscriber?

  A. Drop Journal, remove existing subscribers, add a new subscriber, start Journal, and edit the default Journalizing filter in your Interfaces
  B. Drop Journal,add anew subscriber, start Journal, and remove the default Journalizing filter in your Interfaces
  C. Drop Journal, add a new subscriber, start Journal, and edit the default Journalizing filter in your Interfaces
  D. Add anew subscriber and edit the default Journalizing filter in your Interfaces
  D. Add anew subscriber and edit the default Journalizing filter in your Interfaces

  ---

  You can add subscribers after starting the journals. Subscribers added after journal startup will only retrieve changes captured since they were added to the subscribers list.

• Question 3:

  One of the parameters retrieve column properties in a knowledge module is odiRef.getcolList.

  What is the name of the parameter that retrieves the datatype of a mapped target column?

  A. DEST_DT
  B. SOURCE_DT
  C. COL_DESC
  D. COL_FORMAT
  A. DEST_DT

  ---

  http://gerardnico.com/doc/odi/webhelp/en/ref_api/getcollist.html

• Question 4:

  When profiling data with EDQ, how can you ensure that the latest data is being used?

  A. By creating a snapshot
  B. By refreshing a snapshot by running it
  C. New data is automatically loaded by EDQ, no action is required.
  D. By creating a data store
  B. By refreshing a snapshot by running it

  ---

  http://www.oracle.com/webfolder/technetwork/dataquality/edqhelp/Content/concepts/snapshots.htm

• Question 5:

  Select two infrastructure components that can be used to deploy both ODI and EDQ components.

  A. JDeveloper
  B. Oracle WebLogic Server
  C. IBM WebSphere Application Server
  D. Oracle SOA Suite
  B. Oracle WebLogic Server
  C. IBM WebSphere Application Server

  ---

  http://docs.oracle.com/cd/E48549_01/doc.11117/e40040/configuring.htm "Configuring EDQ on WebLogic Server"

  "Configuring EDQ on Tomcat or WebSphere"

  and here:

  http://docs.oracle.com/cd/E28280_01/integrate.1111/e12643/whatsnew.htm " ODI Agents and datasources can now be deployed on Oracle WebLogic Server (WLS) and IBM WebSphere Application Server (WAS)"

• Question 6:

  To load a specific table using ODI, do you need to draw directly in the flow all details about how the different servers involved are connected?

  A. Yes, and also specify with variables the passwords for connecting to the data contained in the servers.
  B. No, the code will be black box-generated directly by ODI.
  C. No, ODI automatically designs the flow and how servers are connected.
  D. In the ODI interface palette, choose the more convenient graphic objects to link the involved servers.
  C. No, ODI automatically designs the flow and how servers are connected.

• Question 7:

  You are designing a Load Plan in which you need to run Interfaces A and B one after the other while running Interface C at the same time. Which steps do you need to follow to achieve this?

  A. Add a Parallel step, add two Serial steps underneath it, and then add A and B to one serial step and C to the other one
  B. Add a Parallel step, drag A and B and C into the Parallel step
  C. Add aParallel step, add two Parallel steps underneath it, and then add A and B to one Parallel step and C to the other one
  D. Add a Parallel step, add three serial steps underneath it, and then add A to the first Serial step, to the second one, and then C to the last one
  A. Add a Parallel step, add two Serial steps underneath it, and then add A and B to one serial step and C to the other one

• Question 8:

  In ODI Operator, is it possible to view code in the second level (the step) represented?

  A. No, it is only possible to see code in the first higher level (the session) represented.
  B. Yes, all generated code can be viewed together in the step-level, with a complete list of executed code.
  C. Yes, depending on the auditlevel declared when running the execution, some of the generated code at the step-level can be viewed.
  D. No, it is possible to view code in the thud level(the tasklevel)represented.
  D. No, it is possible to view code in the thud level(the tasklevel)represented.

• Question 9:

  Select two correct answers. ODI and EDQ can share the same infrastructure If__________.

  A. They use an Oracle DB as a repository and WebLogic to host the web application
  B. They use an Oracle DB as a repository and WebSphere to host the web application
  C. They use any DB as a repository and any compatible web application server
  D. They use an Oracle DB as a repository and Tomcat to host the web application
  E. ODI and EDQ cannot share the same infrastructure, they both have different architecture
  A. They use an Oracle DB as a repository and WebLogic to host the web application
  B. They use an Oracle DB as a repository and WebSphere to host the web application

• Question 10:

  Select the correct statement in an ODI interface, each column of the target can have at most, one mapping in a given dataset.

  A. No,a targetcolumn can have multiple defined mappings.
  B. No, a variable is used to evaluate if the target column can have more than one mapping.
  C. Yes, a target column can have a unique and well-defined mapping.
  D. Yes, a target column can have a unique definition, but an ODI procedure can define additional mappings for that column.
  C. Yes, a target column can have a unique and well-defined mapping.

  ---

  Reference: http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm