Oracle Apps Training

IZ0-451 Q&A 79

2011-11-22T19:18:00.000-08:00

You are implementing a BPEL process for your client. In the implementation scenario, the BPEL process sends a request to a service and waits until it receives a reply, or until a certain time limit is reached, which ever comes first. Which activity will be used to achieve this.

A. Pick.

B. Assign.

C. Wait.

D. While.

Answer: A

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

IZ0-451 Q&A 78

2011-11-22T19:17:00.000-08:00

Which two statements are true regarding developing SOA composite applications using Oracle jdeveloper?

A. A service component can be created only using the SOA composite editor.

B. A project development on the same SOA infrastructure must have a unique name across SOA

composite application.

C. When a service component is deleted using SOA composite editor, all references to all are

automatically deleted.

D. When you deleted a component, any WSDL imports used by that component are removed,

even if the WSDL imports are used by other component.

Answer: B,C

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

IZ0-451 Q&A 77

2011-11-22T19:16:00.000-08:00

Which two are BPEL faults?

A. Business faults.

B. Process faults.

C. Runtime faults.

D. Static faults.

E. Dynamic faults.

Answer: A,C

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

IZ0-451 Q&A 76

2011-11-22T19:14:00.000-08:00

Identify two applicable examples of business rules

A. Notifications to alert interested users about a change in the state of a task during the task life cycle.

B. Business policies such as standing policies and approval matrices.

C. Computations such as discounts or premiums.

D. Activities that are required to advance the business process.

Answer: B,C

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

IZ0-451 Q&A 75

2011-11-22T19:13:00.000-08:00

In Oracle SOA suit 11g embedded security is enabled via...........

A. Oracle service bus as a security gateway.

B. Embedded OWSM agents to the SOA service infrastructure.

C. Out-of-the box installation of the OWSM gateway.

D. Custom installation of the OWSM gateway.

Answer: B

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

IZ0-451 Q&A 74

2011-11-22T19:10:00.000-08:00

By using technology, you enable to be more adaptable to change. It is easier to alter rules to meet

the changing needs of the business, enabling the application to be more responsive to business

requirements. This benefit of business rule can be defined as................

A. Agility

B. Transparency

C. Availability

D. Accessibility

Answer: A

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

IZ0-451 Q&A 73

2011-11-22T19:09:00.000-08:00

Which routing rule type in an Oracle mediator component externalizes routing logic to a Oracle rules dictionary?

A. Dynamic.

B. Static.

C. Request.

Answer: A

Go to HOME_PAGE

IZ0-451 Q&A 72

2011-11-22T19:08:00.000-08:00

What do the Oracle business rules components inside?

A. Rules engine.

B. Rule editor.

C. Rule dictionary.

D. Rules evaluation.

E. Rules library

Answer: Not sure :)

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

IZ0-451 Q&A 71

2011-11-22T19:05:00.000-08:00

Which two statements are true about proxy service in Oracle service bus (OSB)?

A. Proxy services are OSB definitions of enterprise services that exchange messages during

businesses processes and they do not have a pipeline

B. Proxy services are definitions of generic intermediary web services that are hosted locally on Oracle service bus.

C. Proxy services can be configured using Oracle Jdeveloper.

D. Message handling capabilities of proxy service are implemented with message flow definitions using a pipeline.

Answer: B,D

Go to HOME_PAGE

Thanks to Srinivasulu Kummitha for sharing this.

OM Setup Video

2011-11-18T09:28:00.000-08:00

1) Create transaction Type at header and Line Level

2) Create Defaulting Rules

3) Create Sales Order Creation

4) Document Sequence

5) Copy Sales Order

Oracle Training Videos

2011-11-18T09:22:00.000-08:00

Module specific videos are captures here. It has links from You tube where I have loaded the files.

OM Setup Video

IZ0-451 Q&A 70

2011-06-07T20:05:00.000-07:00

Identify three major enablers of Oracle SOA 11g .

A. Business process execution language.
B. WSRP
C. SCAWSDL
D. OSGI
E. Net

Answer: A,B,E

Go to HOME_PAGE

IZ0-451 Q&A 69

2011-06-07T20:02:00.000-07:00

Identify two features of event delivery network (EDN).

A. Aligns SOA with event driven architecture (EDA).
B. Supports a public subscribe declarative model.
C. Facilitates services innovations and events to be mixed and matched.
D. Provide the split join web services.

Answer: B,D

Go to HOME_PAGE

IZ0-451 Q&A 68

2011-06-07T19:58:00.000-07:00

Choose three operations that are supported by Oracle file adapter?

A. Read file.
B. Fetch file.
C. List files.
D. Write file.
E. Delete file.

Answer: A,C, D

Go to HOME_PAGE

IZ0-451 Q&A 67

2011-06-07T19:53:00.000-07:00

Which two statements are about Oracle SOA suit 11g BPEL component when using the entity?

A. Data operations such as loading and saving are performed automatically by the data provider
service with out asking to code any service in vocation
B. Data operation such as explicitly loading and saving data are performed by the data base
adapter in Oracle BPEL process manager
C. Data in variables is in service data object form. (SDO)
D. Data in variable is in document object (DOM) form.

Answer: A,B

Go to HOME_PAGE

IZ0-451 Q&A 66

2011-06-07T19:51:00.001-07:00

You are using Oracle jdeveloper 11g composite editor tool to built a composite application. Which
service lime will you use to define your interfaces to the composite?

A. Reference services lane.
B. Exposed services lane.
C. External services lane.
D. Internal services lane.

Answer: B

Go to HOME_PAGE

IZ0-451 Q&A 65

2011-06-07T19:49:00.000-07:00

Which these are valid methods to assign users, groups, and application rules during design time,
to tasks in a human workflow?

A. Assign users, groups, and application rules using XQuerry
B. Assign users, groups, and application rules using LDAP rules and privileges.
C. Assign users, groups, and application rules using business rules.
D. Assign users, groups, and application rules using Oracle Haley.
E. Assign users, groups, and application rules using a delimited string of users, groups, or
application roles.

Answer: E

Go to HOME_PAGE

IZ0-451 Q&A 64

2011-06-07T19:46:00.001-07:00

A BPL process uses to invokes to insert data into two Oracle database tables the first invokes
inserts data into master table and the second invokes insert data into detail table?
Identify the statement that will undo both transactions by throwing the fault if either one of the
transaction faults?

A. throw name-"throw" fault name "bpebrsqlecception"
B. throw name-"throw" fault name "bpetxcroolback"
C. throw name-"throw" fault name "bpetxnuntime fault"
D. throw name-"throw" fault name "bpetxfault"

Answer: A

Go to HOME_PAGE

IZ0-451 Q&A 63

2011-06-07T19:44:00.000-07:00

Which two components can be found on SAO component palette of Oracle SOA component?

A. BPEL process
B. Partner link.
C. Human task.
D. ADF-BC.

Answer: A,C

Go to HOME_PAGE

IZ0-451 Q&A 62

2011-06-07T19:42:00.000-07:00

Service component architecture (SCA) is set of specifications for .........., .........and ........?

A. Implementing applications based on reusability.
B. Implementing business applications using BBEL.
C. A programming model for building applications based on service on service oriented
architecture.
D. Composition of services and creation of service components including the reuse of existing
services.
E. Implementing procedural models to built software applications.

Answer: A,C,D

Go to HOME_PAGE

IZ0-451 Q&A 61

2011-06-07T19:40:00.000-07:00

Human task service prevents tasks to users via which channels?

A. Oracle BPM wordlist application.
B. Oracle forms based notification.
C. Actionable notification sent via sms.
D. Actionable notification sent via Email.

Answer: A,D

Go to HOME_PAGE

IZ0-451 Q&A 60

2011-06-07T19:37:00.000-07:00

Oracle SOA suit 11g has two components, mediator and Oracle service bus. Both provide
transformation and validation functionality. Which two statements are true.

A. The mediator is an intra-composite component responsible for brokering communications
between components that make up a composite, enabling transformation, routing and payload
validation inside the component.
B. The mediator is stand alone component responsible for brokering communications between
service end points enabling transformation, routing and payload validation.
C. Oracle service bus is stand alone component responsible for brokering communications
between service endpoints enabling transformation, routing and pay load validation.

Answer: A,C

IZ0-451 Q&A 59

2011-06-07T19:30:00.000-07:00

The event delivery network is designed for handling asynchronous messaging arising from a
business event or service and supports.............

A. Request-response model.
B. Publish-subscribe declarative model.
C. Fire-forget model.
D. Request-reply model.

Answer: C

Go to HOME_PAGE

IZ0-451 Q&A 58

2011-06-07T19:28:00.000-07:00

Your Oracle SOA composite is running in production but due to new government mandate you
have to update the security policy based on Oracle web service manager. What are your options
to update the security policy?

A. Attach updated policy via the command line interface.
B. Attach updated policy in jdeveloper and redeploy component.
C. Attach policy in enterprise model console test it and reattach with out redeployment.
D. Attach policy via web logic admin console after deployment.

Answer: B

Go to HOME_PAGE

IZ0-451 Q&A 57

2011-06-07T19:22:00.000-07:00

Using the Oracle BPM worklist application, a user can do which three things.

A. Perform authorized actions on tasks.
B. Create personal tasks.
C. Define delegation rules.
D. Define user groups.
E. Define task routing policy.

Answer: A,B,C

Go to HOME_PAGE

IZ0-451 Q&A 56

2011-05-08T11:20:00.000-07:00

Two types of services with transactional behavior that can be implemented in Oracle database
adapters and.................

A. File adapters.
B. Service data objects.
C. SOAP Endpoints.
D. Active server objects.

Answer: C

Go to HOME_PAGE

IZ0-451 Q&A 55

2011-05-08T11:16:00.000-07:00

IZ0-451 Q&A 54

2011-05-08T11:11:00.000-07:00

For business rules, a rules dictionary contains one or more definitions of: facts; constraints;
functions; rule sets. Identify the correct statement that defines the facts.
A. Has a collection of facts type, global variables constants function and rulesets.
B. Are declared as: "if condition than action".
C. Have an action: assign, assert, call function (or java method)
D. Are data or business objects on which the rule engine evaluates the rule condition.

Answer: A
Go to HOME_PAGE

IZ0-451 Q&A 53

2011-05-08T11:07:00.000-07:00

Which three components can be used to configure a human task?
A. Task management service.
B. Task routing service.
C. Data service.
D. Identity service.
E. Security service

Answer: B,D,E

Go to HOME_PAGE

IZ0-451 Q&A 52

2011-05-08T10:58:00.000-07:00

Oracle SOA suite 11g configured with the ................. application that enables the composite
application components to send application?

A. Workload
B. User messaging service
C. Worklist
D. Workflow

Answer: C

Go to HOME_PAGE

IZ0-451 Q&A 51

2011-04-03T11:23:00.000-07:00

Identify the correct order in which the fault management framework attempts to identify a fault
policy binding?

BPEL process or Oracle mediator service component defined in the composite xml file.SOA
composite application defined in the composite XML file.Reference binding component defined in
the composite XML file.

A. 1, 2, 3
B. 3, 1, 2
C. 3, 2, 1
D. 1, 3, 2

Correct: B

IZ0-451 Q&A 50

2011-04-03T11:19:00.000-07:00

What is the purpose of Oracle BPEL process manager dehydration store?

A. The dehydration store is used to save all state information in a database to avoid showing down
the system due to too much IO.
B. The dehydration store is used to store the process state for long-running process which will
allocate memory to be given back to the system and will not consume resources while waiting.
C. The dehydration store is good way to preserve long running processes, and it prevents any
location of state or reliability if a system shut down

Correct: C

Go to HOME_PAGE

IZ0-451 Q&A 49

2011-04-03T11:13:00.000-07:00

What is true when implementing human reactions that are part of composite applications using the
human task component in SOA 11g?

A. The human task configuration is stored in the "task" metadata file.
B. The human task service uses an identity directory, such as LDAP, to determine people rules
and privileges.
C. The human task service engine executes all the human task components in SOA composite
application.
D. The human task is not available in standalone mode is always associated with BPEL process
service component.
E. The wordlist application can also be used to change the human task configuration.

Correct: D

Go to HOME_PAGE

IZ0-451 Q&A 48

2011-04-03T03:30:00.000-07:00

48. The faults that are defined by WS-BPEL specifications are _____________. Mark for Review
(1) Points

Business Faults

Runtime Faults

Standard Faults

Basic Faults

correct: The faults that are defined by WS-BPEL specifications are Standard Faults.

Go to HOME_PAGE

IZ0-451 Q&A 47

2011-04-03T03:28:00.000-07:00

47. What is a Composite in SCA? Mark for Review
(1) Points

(Choose all correct answers)

A composite is the unit of deployment for SCA.

A composite holds services that can be accessed remotely.

A composite contains one or more components.

None of the above

Correct: A Composite is the unit of deployment for SCA. It holds services that can be accessed remotely and it contains one or more components.

Go to HOME_PAGE

IZ0-451 Q&A 46

2011-04-03T03:26:00.000-07:00

1. Which routing rules are supported by the Oracle Mediator?

(Choose all correct answers)

Rule-based

Request

Static

Dynamic

Correct: Oracle Mediator supports Static and Dynamic routing rules.

Go to HOME_PAGE

IZ0-451 Q&A 45

2011-04-03T03:25:00.000-07:00

45. Choose the document types that B2B supports. Mark for Review
(1) Points

(Choose all correct answers)

RosettaNet

HL7

EDI

ebXML

Correct: B2B supports HL7, RosettaNet, ebXML, and EDI.

Go to HOME_PAGE

IZ0-451 Q&A 44

2011-04-03T03:23:00.000-07:00

44. SDO provides a metadata API, which allows applications, tools, and frameworks to introspect the data model for a data graph. Mark for Review
(1) Points

True

False

Correct: True: SDO provides a metadata API, which allows applications, tools, and frameworks to introspect the data model for a data graph.

Go to HOME_PAGE

IZ0-451 Q&A 43

2011-04-03T03:22:00.000-07:00

43. On what IDE is Oracle's SOA Composite Editor based? Mark for Review
(1) Points

NetBeans

Eclipse

JDeveloper

All answers apply

Correct: Oracle's SOA Composite Editor is based on JDeveloper.

Go to HOME_PAGE

IZ0-451 Q&A 42

2011-04-03T03:19:00.000-07:00

42. Oracle Service Bus can monitor the performance of proxy and business services and fire alerts based upon ________________. Mark for Review
(1) Points

SLA definitions

Message definitions

KPI definitions

Service definitions

Correct: Oracle Service Bus can monitor the performance of proxy and business services and fire alerts based upon SLA definitions.

Go to HOME_PAGE

IZ0-451 Q&A 41

2011-04-03T03:17:00.000-07:00

41. The task routing service deals with the dispatching and assigning of tasks. Mark for Review
(1) Points

True

False

Correct: True: The task routing service deals with the dispatching and assigning of tasks.

Go to HOME_PAGE

IZ0-451 Q&A 40

2011-04-03T03:11:00.000-07:00

40. The ____________ component uses the concept of Process Orchestration. Mark for Review
(1) Points

BPEL

Human Task

Business Rules

Mediator

Correct: The BPEL component uses the concept of Process Orchestration.

Go to HOME_PAGE

IZ0-451 Q&A 39

2011-04-03T03:10:00.000-07:00

39. What is the default underlying messaging platform in Oracle SOA Suite 11g? Mark for Review
(1) Points

MQ Series

MSMQ

Oracle AQ

WLS JMS

Correct: WLS JMS is the default messaging platform in SOA Suite11g.

Go to HOME_PAGE

IZ0-451 Q&A 38

2011-04-03T03:08:00.000-07:00

38. SCA components are integrated together into one application and communicate with the outside world through binding components such as __________ and _________.

(Choose all correct answers)

EDA

JCA adapters

Web services

Artifacts

Correct: SCA components are integrated together into one application and communicate with the outside world through binding component

Go to HOME_PAGE

IZ0-451 Q&A 37

2011-04-03T03:07:00.000-07:00

37. A _____________ is a collection of one or more rules that are seen as a unit of execution. Mark for Review
(1) Points

Bucketset

Dictionary

Fact

Ruleset

Correct: A Ruleset is a collection of one or more rules that are seen as a unit of execution.

Go to HOME_PAGE

IZ0-451 Q&A 36

2011-04-03T03:01:00.000-07:00

36. Which methods are supported by OWSM to attach web services policy to a SCA composite? Mark for Review
(1) Points

(Choose all correct answers)

Attach a policy via the command line interface

Attach a policy in JDeveloper and deploy with normal deployment

Attach a policy in the EM console after deployment

None of the above

Correct: There are only 2 ways you can attach web services policy to a SCA composite: JDeveloper and the Enterprise Manager console.

Go to HOME_PAGE

IZ0-451 Q&A 35

2011-04-03T02:57:00.000-07:00

35. The SCA component used for service orchestration in a business service is the _________________ component. Mark for Review
(1) Points

Mediator

Business Rules

BPEL

Human Task

Correct: The SCA component used for service orchestration in a business service is the BPEL component.

Go to HOME_PAGE

IZ0-451 Q&A 34

2011-04-03T02:52:00.000-07:00

34. SCA is an assembly model for SOA-style applications.

True

False

Correct: True: SCA provides an assembly model for SOA-style applications.

Go to HOME_PAGE

IZ0-451 Q&A 33

2011-04-03T02:51:00.000-07:00

33. Which is the orchestration component of Oracle SOA infrastructure?

Adapters

Business Activity Monitoring (BAM)

Rules Engine

BPEL/BPM Engine

Correct: The BPEL/BPM Engine represents the orchestration component of SOA infrastructure.

Go to HOME_PAGE

IZ0-451 Q&A 32

2011-04-03T02:50:00.000-07:00

32. With____________, you can design Oracle Human Task display forms that depict the human task in the SOA composite.

Oracle BI Publisher

Oracle CRM OnDemand

Oracle ADF

Oracle BPEL

Correct: With Oracle ADF, you can design Oracle Human Task display forms that depict the human task in the SOA composite.

Go to HOME_PAGE

IZ0-451 Q&A 31

2011-04-03T02:47:00.000-07:00

31. In Enterprise Manager, each instance is uniquely identified with a ____________? Mark for Review
(1) Points

ECID

GUID

CXF

RFID

Correct: In Enterprise Manager, each instance is uniquely identified with an ECID.

Go to HOME_PAGE

IZ0-451 Q&A 30

2011-04-03T02:45:00.000-07:00

30. The policy-based fault-handling is flexible enough to allow defining how faults are handled. The policies can be bound to either the SCA composite as a whole or be associated with the individual components. Mark for Review
(1) Points

True

False

correct: The policy-based fault-handling is flexible enough to allow defining how faults are handled. The policies can be bound to either the SCA composite as a whole or be associated to the individual components.

Go to HOME_PAGE

IZ0-451 Q&A 29

2011-04-03T02:44:00.000-07:00

29. Oracle BPEL Process Manager supports two data forms. Which are these?

(Choose all correct answers)

COM (Component Object Model)

DOM (Document Object Model)

NDO (Net Data Objects)

SDO (Service Data Objects)

Correct: Oracle BPEL Process Manager supports two data forms: DOM and SDO.

Go to HOME_PAGE

IZ0-451 Q&A 28

2011-04-03T02:42:00.000-07:00

28. An Oracle JDeveloper web service test tool enables initiating composite applications and viewing responses. Mark for Review
(1) Points

True

False

Correct: True: An Oracle JDeveloper web service test tool enables initiating composite applications and viewing responses.

Go to HOME_PAGE

IZ0-451 Q&A 27

2011-04-03T02:38:00.000-07:00

27. Which categories of faults are supported by a BPEL process in SOA Suite 11g?

(Choose all correct answers)

Integration

Monitoring

Runtime

Business

Correct: A BPEL process in SOA Suite supports the Business and Runtime fault categories.

Go to HOME_PAGE

IZ0-451 Q&A 26

2011-04-03T02:36:00.000-07:00

26. The Mediator Component provides rich fault-handling constructs for catching exceptions and acting upon them. Mark for Review
(1) Points

True

False

Correct: The answer is false. It is the BPEL component that provides rich fault-handling constructs for catching exceptions and acting upon them.

Go to HOME_PAGE

IZ0-451 Q&A 25

2011-04-03T02:35:00.000-07:00

25. The _____________ exposes database operations that can be implemented and used by components in a composite application. Mark for Review
(1) Points

Socket Adapters

File Adapters

Database Adapters

Oracle Application Adapters

Correct: The Database Adapters expose database operations that can be implemented and used by components in a composite application.

Go to HOME_PAGE

IZ0-451 Q&A 24

2011-04-03T02:33:00.000-07:00

24. The Mediator component enables target services to receive data in the desired format. Mark for Review
(1) Points

True

False

Correct: True: The Mediator component enables target services to receive data in the desired format.

Go to HOME_PAGE

IZ0-451 Q&A 23

2011-04-03T02:28:00.000-07:00

23. Faults are notified and handled differently for synchronous and asynchronous invocations. Mark for Review
(1) Points

True

False

Correct: True: Faults are notified and handled differently for synchronous and asynchronous invocations.

Go to HOME_PAGE

IZ0-451 Q&A 22

2011-04-03T02:24:00.000-07:00

22. Which component of the Oracle SOA Suite is responsible for transformation/routing? Mark for Review
(1) Points

Mediator

Rules Engine

Business Activity Monitoring (BAM)

BPEL/BPM Engine

Correct: Mediator is used for transformation and routing in the Oracle SOA Suite.

Go to HOME_PAGE

IZ0-451 Q&A 21

2011-04-03T02:22:00.000-07:00

21. Content-based routing is supported by the Dynamic Routing feature using _______________________. Mark for Review
(1) Points

XPath expressions (*)

regular expressions

irregular expressions

Xlink expressions

Correct: Content-based routing is supported by the Dynamic Routing feature using XPath expressions.

Go to HOME_PAGE

IZ0-451 Q&A 20

2011-04-03T02:13:00.000-07:00

20. A(n) _____________ is an instance of an Oracle WebLogic Server used to host customer deployed applications. Mark for Review
(1) Points

Administrator Server

Portal server

Security server

Managed Server

Correct: Managed Server is an instance of an Oracle WebLogic Server used to host customer deployed applications.

Go to HOME_PAGE

IZ0-451 Q&A 19

2011-04-03T02:10:00.000-07:00

19. A ____________ if defined, overrides the fault handing in the BPEL process, and it must re-throw the fault for the BPEL process catch block to handle the fault. Mark for Review
(1) Points

fault activity

fault rule

fault exception

fault policy

Correct: If a fault policy is defined, it overrides the fault handing in the BPEL process and it must re-throw the fault for the BPEL process catch block to handle the fault.

Go to HOME_PAGE

IZ0-451 Q&A 18

2011-04-03T02:07:00.000-07:00

18. Automated upgrade of 10g design-time artifacts is supported for ________________. Mark for Review
(1) Points

Oracle BPEL and Oracle ESB

Oracle BPEL Only

Oracle ESB Only

None

Correct: Automated upgrade of 10g design-time artifacts is supported for Oracle BPEL and Oracle ESB.

Go to HOME_PAGE

IZ0-451 Q&A 17

2011-04-03T02:06:00.000-07:00

17. Oracle Mediator supports parallel execution of routing rules for Mediators with synchronous interface. Mark for Review
(1) Points

True

False

Correct: The answer is FALSE. Proxy Services have message flows and provide mediation capabilities such as data transformation.

Go to HOME_PAGE

IZ0-451 Q&A 16

2011-04-03T02:04:00.000-07:00

16. The Oracle JDeveloper IDE provides design and edit tools that enable the creation of SOA composite applications. Mark for Review
(1) Points

True

False

Correct: True: The Oracle JDeveloper IDE provides design and edit tools that enable the creation of SOA composite applications.

Go to HOME_PAGE

IZ0-451 Q&A 15

2011-04-03T01:56:00.000-07:00

15. A Bucketset is used as a constraint to define a set of acceptable values for a fact or a property.

True

False

Correct: True.

IZ0-451 Q&A 14

2011-04-03T01:49:00.000-07:00

14. Which component of SOA Suite 11g performs administrative tasks like configuring, monitoring, and managing of runtime artifacts?

Oracle Enterprise Registry

Oracle Enterprise Repository

Oracle Enterprise Manager

Oracle Enterprise Service Bus

Correct: Oracle Enterprise Manager performs administrative tasks like configuring, monitoring, and managing of runtime artifacts.

Go to HOME_PAGE

IZ0-451 Q&A 13

2011-04-03T01:38:00.000-07:00

13. In order to implement end-to-end SOA governance, what types of management should you address?

(Choose all correct answers)

SOA monitoring and management

SOA asset management

consumer management

policy management

Correct: True: In order to implement end-to-end SOA governance, you need to address SOA asset management, consumer management, policy management, and SOA monitoring and management.

Go to HOME_PAGE

IZ0-451 Q&A 12

2011-04-03T01:32:00.000-07:00

12. For which use cases should ODI be recommended ?

Large Volumes

Large Payload

Real Time OLTP

Batch

Correct: ODI is recommended for the Large Payload used case.

Go to HOME_PAGE

IZ0-451 Q&A 11

2011-04-03T01:08:00.000-07:00

11. If there is a composite application with a Mediator that receives multiple callbacks, the behavior of the composite application is _____________.

determined

predictable

undetermined

chaotic

Correct: If there is a composite application with a Mediator that receives multiple callbacks, the behavior of the composite application is undetermined.

Go to HOME_PAGE

IZ0-451 Q&A 10

2011-04-03T01:06:00.000-07:00

10. The SOA reference architecture is a blueprint to guide the enterprise toward SOA success Mark for Review
(1) Points

True

False

Correct: True: The SOA reference architecture is a blueprint to guide the enterprise toward SOA success.

Go to HOME_PAGE

IZ0-451 Q&A 9

2011-04-03T01:02:00.001-07:00

9. How do messages travel through a pipeline?

They don't travel.

both ways

back and forth

one-way

Correct: Messages travel one-way through a pipeline.

Go to HOME_PAGE

IZ0-451 Q&A 8

2011-04-03T00:58:00.000-07:00

8. A SOA domain can be created using WLS domain configuration wizard. Mark for Review
(1) Points

True

False

Correct: The answer is true: A SOA domain can be created using the WLS domain configuration wizard.

Go to HOME_PAGE

IZ0-451 Q&A 7

2011-04-03T00:54:00.000-07:00

7. What types of pipelines are supported in Oracle Service Bus? Mark for Review
(1) Points

(Choose all correct answers)

Request

Composite

Response

Error

Correct: Oracle Service Bus supports Request, Response, and Error pipelines.

Go to HOME_PAGE

IZ0-451 Q&A 6

2011-04-03T00:42:00.000-07:00

What are the primary features of Oracle SOA Infrastructure?

(Choose all correct answers)

Route/Transform

Connect

Build/Reuse

Orchestrate

Correct: All are primary features: Build/Reuse, Connect, Route/Transform, and Orchestrate.

Go to HOME_PAGE

IZ0-451 Q&A 5

2011-04-03T00:37:00.000-07:00

5. The SCA Assembly Model represents_____________, which are defined by elements contained in XML files. Mark for Review
(1) Points

a series of artifacts

a series of query languages

a series of activities

a series of adapters

Correct: The SCA Assembly Model represents a series of artifacts, which are defined by elements contained in XML files.

Go to HOME_PAGE

IZ0-451 Q&A 4

2011-04-03T00:31:00.000-07:00

4. The type of services with transactional behavior that can be implemented in SOA Suite 11g are web services that execute SQL transactions, database adapters and ______________.

Service Data Objects (*)

JMS Adapters

File Adapters

SOAP Endpoints

Correct: The type of services with transactional behavior that can be implemented in SOA Suite 11g are web services that execute SQL transactions, database adapters and Service Data Objects.

Go to Home_page

IZ0-451 Q&A 3

2011-04-03T00:26:00.001-07:00

3. Routing Rules in Oracle Mediator component enables to externalize the routing logic to a Oracle Rules Dictionary. Mark for Review
(1) Points

Static

Request

Dynamic

Response

Correct: Dynamic Routing Rules in Oracle Mediator component enables to externalize the routing logic to a Oracle Rules Dictionary.

Go to HOME_PAGE

IZ0-451 Q&A 2

2011-04-03T00:21:00.000-07:00

2. In Oracle Business Rules, __________ describes a restricted list of values, or range of values for a given data type of a fact. Mark for Review
(1) Points

Bucketkit

Buckethandle

Bucketgroup

Bucketset

Correct: In Oracle Business Rules, Bucketset describes a restricted list of values, or range of values for a given data type of fact.

Go to HOME_PAGE

IZ0-451 Q&A 1

2011-04-03T00:09:00.000-07:00

The SOA governance framework is centered on ___________, process, technology, and services.

1) People

2) Value

3) Strategy

4) Risk

Correct: The SOA governance framework is centered on people, process, technology, and services.

Go to HOME_PAGE

IZ0-451 Oracle SOA Foundation sample orhttp://www.blogger.com/img/blank.gif practice question and Answers

2011-04-03T00:02:00.000-07:00

This article would help for sure who ever preparing for the "Oracle SOA Foundation Practitioner" IZ0-451. And for one who want to know more about the SOA suite 11g.

1) Q&A1

2) Q&A2

3) Q&A3

4) Q&A4

5) Q&A5

6) Q&A6

7) Q&A7

8) Q&A8

9) Q&A9

10) Q&A10

11) Q&A11

12) Q&A12

13) Q&A13

14) Q&A14

15) Q&A15

16) Q&A16

17) Q&A17

18) Q&A18

19) Q&A19

20) Q&A20

21) Q&A21

22) Q&A22

23) Q&A23

24) Q&A24

25) Q&A25

26) Q&A26

27) Q&A27

28) Q&A28

29) Q&A29

30) Q&A30

31) Q&A31

32) Q&A32

33) Q&A33

34) Q&A34

35) Q&A35

36) Q&A36

37) Q&A37

38) Q&A38

39) Q&A39

40) Q&A40

41) Q&A41

42) Q&A42

43) Q&A43

44) Q&A44

45) Q&A45

46) Q&A46

47) Q&A47

48) Q&A48

49) Q&A49

50) Q&A50

51) Q&A51

52) Q&A52

53) Q&A53

54) Q&A54

55) Q&A55

56) Q&A56

57) Q&A57

58) Q&A58

59) Q&A59

60) Q&A60

61) Q&A61

62) Q&A62

63) Q&A63

64) Q&A64

65) Q&A65

66) Q&A66

67) Q&A67

68) Q&A68

69) Q&A69

70) Q&A70

71) Q&A71

72) Q&A72

73) Q&A73

74) Q&A74

75) Q&A75

76) Q&A76

77) Q&A77

78) Q&A78

79) Q&A79

Declaimer: The Answers given for all the questions are best of my knowledge. I may be wrong. for few of them. I would be Appreciate if you can correct me.

More would be Added soon..................... Keeping watching.

Know license applications

2010-03-09T19:19:00.000-08:00

Know license applications:-
-------------------------------

Lot many times we would not be known if the client has the specific application license or not.

We can ask the client is one way. If you have access to the back-end for the production Instance. Then you could know with following query. This is the Other way.

All the applications which are Installed status are license one.

SELECT application_name
, application_short_name
,DECODE (status, 'I', 'Installed', 'S', 'Shared', 'Not Installed') status
, a.application_id
,i.patch_level
FROM fnd_application_all_view a
, fnd_product_installations i
WHERE a.application_id = i.application_id
ORDER BY 1;

Install base creation issue approach

2010-01-22T19:47:00.000-08:00

Install base creation issue approach:-
-----------------------------------------------

I have made some package which could help creating the Install base for the sales order.

You can find above package posting under (OM) Ready scripts.

http://alloracletech.blogspot.com/2009/04/install-base-creation-for-all-sales.html

This posting helps you understand Install base issues.

After running the program, if we are still not able to see the Install base created. Check the following steps.

1) Query for the item in the Master item Form and Under Service Tab, you could find option "Installed Base Tracking" Option. This should be enabled for the Install base Creation.

2) Transaction's should be there for the Orders to created the Install base.

You can use the following Query to know the transaction ID's for your Order.

SELECT transaction_id
FROM mtl_material_transactions
WHERE trx_source_line_id IN (select line_id from oe_order_lines_all
where header_id IN (select header_id from oe_order_headers_all
where order_number = 'Your Order Number'))
AND transaction_type_id = 33

Note:- Transaction_type_id is 33 in my instance. This value is Instance dependent.

3) If Transactions are created for the Order but still there is no Install base created then check if there is any error for the Transaction in the Error Table.

You can use the following Query to get Error Information.

select * from csi.csi_txn_errors where TRANSACTION_ID IN (SELECT transaction_id--, trx_source_line_id
FROM mtl_material_transactions
WHERE trx_source_line_id IN (select line_id from oe_order_lines_all
where header_id IN (select header_id from oe_order_headers_all
where order_number = 'Your Order Number'))
AND transaction_type_id = 33);

Note:- Transaction_type_id is 33 in my instance. This value is Instance dependent.

Based on the Error Message, you can go ahead for the Solution. Metalink would be best to get the Solution with the complete error message you found.

4) If there is no errors for this transaction then there is possibility that records are in Interface tables.

In this case you can run the following program to hit records from Interface tables to the Install base tables.

Program Name: Resubmit Interface Process

You can verify if the Install base created or not from the following Query.

select * from csi.csi_item_instances
where last_oe_order_line_id IN (Your Order Line ID);

Example:-

select * from csi.csi_item_instances
where last_oe_order_line_id IN (6912858, 6912859, 6912860);

I hope you find the above information help full.

Note:- I have tested above script in the 11i Instances.

Know Instance Name

2010-01-20T21:42:00.000-08:00

Know Instance Name:-
-------------------------

Following Query can be used to know the Instance Name you are working from the Backend.

SELECT UPPER(sys_context('USERENV','DB_NAME')) "Instance"
FROM DUAL;

On-hand inventory information

2009-11-20T07:59:00.000-08:00

On-hand inventory information:-
--------------------------------------

The following select statement would extracts all on-hand inventory information from Oracle
Applications base tables.

Note:- You may need to modify the query to match with your instance conditions and your requirements.

SELECT
NVL(substr(org.organization_code, 1,3), ' ') orgcode
,NVL(substr(msi.segment1, 1, 8), ' ') seg11
,NVL(substr(msi.segment1, 9, 8), ' ') seg12
,NVL(substr(msi.segment1, 17, 4), ' ') seg13
,NVL(moq.subinventory_code, ' ') sub_inv_code
,NVL(to_char(round(sum(moq.transaction_quantity))), ' ') trans_qnty
FROM mtL_system_items msi
,org_organization_definitions org
,mtl_onhand_quantities moq
,hr_organization_units hou
WHERE moq.inventory_iteM_id = msi.inventory_item_id
AND moq.organizatioN_id = msi.organizatioN_id
AND moq.organizatioN_id = org.organizatioN_id
AND moq.organization_id = hou.organization_id
-- AND hou.type = 'DC'
GROUP BY org.organization_code
, moq.subinventory_code
, msi.segment1;

I hope the above information would be helpful to you.

Credit Card Number (of different format) from specific column

2009-10-27T04:14:00.001-07:00

Credit Card Number (of different format) from specific column:-
--------------------------------------------------------------------------

Following query can be used to get the Credit Card Number (of different format) from specific column.

Column would have credit card Number in the text date. Date is not in any fixed format. And Credit Card Number would also not in any specific Format. In the following query, we have considered few credit card formats. In can include other formats accordingly as your requirement.

This query is contributed with Chandra Kadali. I thank him for this posting.

SELECT jtf_note_id, creation_date, LANGUAGE, notes,
CASE
WHEN INSTR (TRANSLATE (UPPER (notes), '0123456789', '9999999999'),
'99999999999999999'
) > 0
THEN SUBSTR (notes,
INSTR (TRANSLATE (UPPER (notes),
'0123456789',
'9999999999'
),
'99999999999999999'
),
LENGTH ('99999999999999999')
)
WHEN INSTR (TRANSLATE (UPPER (notes), '0123456789', '9999999999'),
'999999999999999'
) > 0
THEN SUBSTR (notes,
INSTR (TRANSLATE (UPPER (notes),
'0123456789',
'9999999999'
),
'999999999999999'
),
LENGTH ('999999999999999')
)
WHEN INSTR (TRANSLATE (UPPER (notes), '0123456789', '9999999999'),
'9999 9999 9999 9999'
) > 0
THEN SUBSTR (notes,
INSTR (TRANSLATE (UPPER (notes),
'0123456789',
'9999999999'
),
'9999 9999 9999 9999'
),
LENGTH ('9999 9999 9999 9999')
)
WHEN INSTR (TRANSLATE (UPPER (notes), '0123456789', '9999999999'),
'9999 999999 99999'
) > 0
THEN SUBSTR (notes,
INSTR (TRANSLATE (UPPER (notes),
'0123456789',
'9999999999'
),
'9999 999999 99999'
),
LENGTH ('9999 999999 99999')
)
WHEN INSTR (TRANSLATE (UPPER (notes), '0123456789', '9999999999'),
'9999-9999-9999-9999'
) > 0
THEN SUBSTR (notes,
INSTR (TRANSLATE (UPPER (notes),
'0123456789',
'9999999999'
),
'9999-9999-9999-9999'
),
LENGTH ('9999-9999-9999-9999')
)
WHEN INSTR (TRANSLATE (UPPER (notes), '0123456789', '9999999999'),
'9999-999999-99999'
) > 0
THEN SUBSTR (notes,
INSTR (TRANSLATE (UPPER (notes),
'0123456789',
'9999999999'
),
'9999-999999-99999'
),
LENGTH ('9999-999999-99999')
)
ELSE 'No Credit card Number'
END "Credit card Number"
FROM jtf_notes_tl
WHERE 1 = 1
AND (TRANSLATE (UPPER (notes), '0123456789', '9999999999') LIKE ('%999999999999999 %') ) -- 15 digit---
OR TRANSLATE (UPPER (notes), '0123456789', '9999999999') LIKE ('%9999999999999999 %')
OR TRANSLATE (UPPER (notes), '0123456789', '9999999999') LIKE ('%9999 9999 9999 9999 %')
OR TRANSLATE (UPPER (notes), '0123456789', '9999999999') LIKE ('%9999 999999 99999 %')
--- below are different formats with '-' instead of ' ''
OR TRANSLATE (UPPER (notes), '0123456789', '9999999999') LIKE ('%9999-9999-9999-9999 %')
OR TRANSLATE (UPPER (notes), '0123456789', '9999999999') LIKE ('%9999-999999-99999 %')

I hope the above information would be helpful to you.

Initialize Apps

2009-10-04T10:39:00.000-07:00

Initialize Apps:-
----------------

To run or execute the Oracle API from the back-end, we need to Initialize the Apps first.

We have API to Initialize the Apps.

To initialize apps using the API, we need to pass few IN parameter values.

The following is the script prepared to initialize apps based on the
Application, User-name and Responsibility name given.

Example:-

DECLARE
   l_appl_id             NUMBER;
   l_appl_name           VARCHAR2 (100) := 'PA';
   l_user_id             NUMBER;
   l_user_name           VARCHAR2 (100) := 'OPERATIONS';
   l_responsibility_id   NUMBER;
   l_resp_name           VARCHAR2 (200)
                                       := 'Projects, Vision Operations (USA)';
BEGIN

-- To get the Application ID of given Application.
   SELECT application_id
     INTO l_appl_id
     FROM fnd_application
    WHERE application_short_name = l_appl_name;

-- To get the User ID information of  given user
   SELECT user_id
     INTO l_user_id
     FROM fnd_user
    WHERE user_name = l_user_name;

-- To get the Resp ID information of the given responsibility.
   SELECT responsibility_id
     INTO l_responsibility_id
     FROM fnd_responsibility_tl
    WHERE responsibility_name = l_resp_name AND application_id = l_appl_id;

--Initialixze the Application to use the API. 
   fnd_global.apps_initialize (l_user_id, l_responsibility_id, l_appl_id);
END;

I Hope the above script would help understanding about the Initializing the Apps API.

Close Notifications

2009-08-28T22:16:00.000-07:00

Close Notifications:-
----------------------

Lot of time we want to close the Notification which has come to the user.

They are many ways to do it. The following script can be use to Close the Notification.

/*********************************************
-- Date 'Current Date'
-- Author JPREDDY
-- Purpose : Close Notifications
**********************************************/
BEGIN
wf_notification.RESPOND( 12504888, -- Notification ID.
'Close requested by on '||Sysdate, -- Comments
'IM12345' ); -- Incident Number.
COMMIT;
END;
/

You can know the status of the Notification from the following Query.

select * from wf_notifications
where NOTIFICATION_ID=12504888

There is some equal-vent API which does this work.

wf_notification.close(12280094 -- Notification ID
,'SYSADMIN');