Answer / ganesh

Trigger: A set of pl/sql statments that are stored
permenantly in the database it activates when ever the DML
operations performed on the table.

constraints: Set of predefind rules are applied on table
column while creating the table or after creating the
table. and automatically performed when DML statemets are
performed by user.

the main differece between the two is
trigger will not effect the existing rows(it will effects
only new rows after creating a trigger on a table),
where as in the constraints it will effect the existing
rows also.

Answer / nilkantha

I can't find the answer.Pls Give me the right answer

in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session

1 Answers  

---

What is the default identifier of structure in C?

3 Answers   CybAge,

---

plz suggest me the book for preparation of NIC exam.

10 Answers   NIC,

---

What is a Transformation?

0 Answers   Informatica,

---

What happens when shared and exclusive locks are applied on data item?

0 Answers  

---

How to do performance tunning a database in DB2 V8.2 UDB in linux

0 Answers  

---

What are the most common databases?

0 Answers  

---

what is data access layer?

0 Answers  

---

What is ole db used for?

0 Answers  

---

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

0 Answers  

---

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

0 Answers  

---

what is the difference between tuple calculus and domain calculus ?

2 Answers   Infosys,

---