Answer Posted / guest

An integrity constraint defines a business rule for a table
column which automatically takes care by Oracle internally.
Intefrity Constraints are NOT NULL,UNIQUE,CHECK ,PRIMARY
KEY,FOREIGN KEY.


A database trigger is a procedure written in PL/SQL and
Will run implicitly when data is modified or when some user
or system actions occur.Triggers are database objects which
gets stored in database and get fires when INSERT or UPDATE
statement attempts to violate the integrity rule, Oracle
must roll back the statement and return an error if trigger
exists.Database triggers are BEFOR/AFTER/{BEFORE|AFTER}
{row|statement etc.

Is sql better than excel?

692

---

how can you see all indexes defined for a table? : Sql dba

704

---

Do we need commit after truncate?

806

---

Is sql a programming?

713

---

What is nvl?

786

---

---

how to use 'mysql' to run sql statements? : Sql dba

732

---

Why we use triggers in mysql?

719

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

711

---

How to return an array from java to pl/sql?

783

---

When is the update_statistics command used?

763

---

What is vector point function?

763

---

What does data normalization mean?

713

---

What is a call statement? Explain with an example.

739

---

What is a join?

807

---

What does where 1 1 mean in sql?

741

---