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.

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

---

How do you declare a constant?

0 Answers  

---

What is spool?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

Why use triggers in sql?

0 Answers  

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

Can we delete column in sql?

0 Answers  

---

Can you inner join the same table?

0 Answers  

---

What is thread join () in threading?

0 Answers  

---

What is the left table in sql?

0 Answers  

---