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

What is a Transformation?

0 Answers   Informatica,

---

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

0 Answers  

---

Explain entity type?

0 Answers  

---

Why do we need distributed database?

0 Answers  

---

what is primary key,unique key, foreign key? can u teach me in simple language?

44 Answers   Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

---

---

plz suggest me the books for the preparation of NIC written exam.

4 Answers   NIC, Rolta,

---

Explain artificial key?

0 Answers  

---

What does new grouping sets enables you to do?

0 Answers   ADITI,

---

What does currency type mean in database?

0 Answers   Amazon,

---

a __________ is a virtual table made up of subset of actual table

2 Answers  

---

What is ole db in ssis?

0 Answers  

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

0 Answers   IBM,

---