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 difference between left and left outer join?

921

---

how mysql optimizes distinct? : Sql dba

1032

---

Which query operators in sql is used for pattern matching?

923

---

What is the need of a partition key?

960

---

What are keys in sql?

963

---

What is the purpose of a sql?

939

---

What are the most important ddl statements in sql?

1060

---

What is coalesce in sql?

1013

---

Can there be more than one function with a similar name in a pl/sql block?

953

---

what are the types of subquery? : Sql dba

1073

---

Is sql developer case sensitive?

966

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

984

---

What is faster join or subquery?

982

---

How is sql used in oracle?

985

---

What are hotfixes and patches?

916

---