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.

what are the differences between binary and varbinary? : Sql dba

1033

---

Can sql function call stored procedure?

1007

---

How do I kill a query in postgresql?

1084

---

Which are sql * plus commands?

1116

---

What is the difference between clustered and non-clustered indexes?

1081

---

What is the difference between sql, mysql and sql server?

1083

---

Are stored procedures faster than dynamic sql?

1022

---

Does sql between include endpoints?

991

---

what is column? : Sql dba

999

---

What is sap sql anywhere?

1060

---

Can we use view in stored procedure?

889

---

What is keys and its types?

1069

---

What is pl sql collection?

953

---

What is a sql*loader control file?

1244

---

Explain the order of sql statement execution?

1035

---