Answer Posted / gourvendra singh

This is for the people who says 'No' to the answer no 7.
As i still believe that it totally depends upon the timings of the trigger.
Consider the below example:
Example1: If i created a trigger as Before insert/update/delete on a table. Whenever user will perform any DML operation on the said table, the trigger will always executes first then it will check the constraint.
Example2: If I created a trigger as After Insert/Update/Delete on a table. Whenever user will perform a DML operation on the said table, the constraint will execute first then the trigger will be executed.
Please mail me if I am wrong on the below mail id:
raviindian2114@gmail.com

What is the function that is used to transfer a pl/sql table log to a database table?

1064

---

What is data control language?

1029

---

differentiate between float and double. : Sql dba

1107

---

Can you join a table to itself?

1219

---

What is difference between pls_integer and integer?

1009

---

What are the different sql languages?

1089

---

Is pl sql and postgresql same?

1179

---

What does truncate mean in sql?

1082

---

How to avoid using cursors?

1175

---

How to create a menu in sqlplus or pl/sql?

1163

---

Which join is default?

1012

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1081

---

Explain the purpose of %type and %rowtype data types?

973

---

Explain cursor types?

1079

---

Can 2 queries be executed simultaneously in a distributed database system?

1189

---