Answer Posted / kiran kumar

Triggers:
--------

1)Defined with create trigger
2)The data dictionary contains source code in the user_triggers.
3)Implicitly invoked
4)Commit, save point and rollback are not allowed(TCL)

Procedures:
-----------

1)Defined with create procedure
2)Data dictionary contains source code in user_source
3)Explicitly invoked
4)Those are allowed

Note: compare both ones with numbers mentioned..

Which oracle apps version you are very confident in?

1191

---

List the types of flexfield?

1030

---

In support project one ticket alloted which steps follows manualy tell me ?

2649

---

What are do's and dont's of Interface?

2401

---

In sequence i want to 11 and 15th values how we will write?

2061

---

Is soa a part of oracle fusion middleware?

1073

---

Explain oracle apps architecture.

1219

---

tell my any difficult situtation you solved in your experience in your company?

2306

---

What are the different components you should consider while defining a responsibility in oracle apps?

1055

---

Tell me how to find the custom directory in front end?

1094

---

what are the prerequisites for costing transactions?

3125

---

What is count(*) from po_vendors(any table)?

1071

---

tell me the scenarios of the independent in reports

2604

---

How can you achieve loose coupling in soa framework?

1202

---

List the various types of value set.

1070

---