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

How to shrink a database?

0 Answers  

---

Display the employees whose salary is less than average salary.

0 Answers   Amazon,

---

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

0 Answers  

---

How do database connections work?

0 Answers  

---

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers  

---

What is dialect in database?

0 Answers  

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

---

There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

0 Answers  

---

What is the Lock Based Protocol used for?

0 Answers   Hexaware,

---

What is difference between clustered, non-clustered and unique index?

0 Answers   Abacus,

---

how do you do sql tuning?

0 Answers   Systel,

---

Explain alternate key?

0 Answers  

---