Answer / kumar jabu

Constraints implements specific conduct or rules on table column like it determines whether field data should be unique,not null ..
But triiger implements rules on systems or application event.
whenever dml occurs that implemented rules been fired.

Answer / naga sindhuri

Triggers not apply for existing rows but constraints can
apply for existing rows.

Answer / milind chopde

1) Constraints can be used for validation but trigger can be used for complex validation and auditing purpose.
2) Trigger is database object but constraint not.
3) Trigger can be fired on DDL commands but constraints are created or altered using DDL commands.
4) Trigger can be fired on particular event like before/after DML but constraint always check before any data insert or update to table.

Is grant a ddl statement?

0 Answers  

---

Explain the working of primary key?

0 Answers  

---

Why left join is used in sql?

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

what is bcp? When is it used?

0 Answers  

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---

Is sql scripting language?

0 Answers  

---

How many indexes can be created on a table in sql?

0 Answers  

---

what is a cursor? : Sql dba

0 Answers  

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---