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 is difference between rank () row_number () and dense_rank () in sql?

1118

---

How does sql*loader handles newline characters in a record? : aql loader

1057

---

How many types of keys are there in sql?

1046

---

How do I view a procedure in sql?

982

---

How do I audit the sql sent to the server?

1019

---

What does pragma mean?

1063

---

What is sql performance tuning?

933

---

what is sql? : Sql dba

1032

---

Which constraints we can use while creating database in sql?

1092

---

what is error ora-03113: end-of-file on communication channel?

1172

---

What is trigger and stored procedure in sql?

1045

---

What is a dirty read sql?

1168

---

Is grant a ddl statement?

906

---

how to get help information from the server? : Sql dba

951

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2198

---