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.

how can we repair a mysql table? : Sql dba

926

---

how to calculate expressions with sql statements? : Sql dba

996

---

How do you respond to dementia behavior?

934

---

What are the various levels of constraints?

1069

---

Will truncate release space?

900

---

What is indexes?

1010

---

What is a common use of group by in sql?

1003

---

Why should I use postgresql?

980

---

How to look at the current sql*plus system settings?

1095

---

What is the use of stored procedures?

987

---

What do you understand by pl/sql packages?

1027

---

What is a field in a database?

1017

---

What is indexing in sql and its types?

1017

---

What is rownum?

932

---

difference between anonymous blocks and sub-programs.

1085

---