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 does count (*) mean?

933

---

Is big data nosql?

949

---

How do I count rows in sql?

1006

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1217

---

What are all the common sql functions?

1030

---

what are all the different normalizations? : Sql dba

1042

---

What is mutating error?

967

---

What makes a good primary key?

1042

---

What is the difference between delete, truncate and drop command?

1151

---

Which query operators in sql is used for pattern matching?

966

---

What does dml mean?

988

---

What types of commands can be executed in sql*plus?

1109

---

Mention what does the hierarchical profiler does?

1090

---

How to call a javascript function from pl sql?

1143

---

What is trigger and how to use it in sql?

1021

---