Answer Posted / lakkireddy ashok

Always trigger will fire first

eg:create table T_CHK (a number check (A < 99));

INSERT INTO T_CHK VALUES(101);

ORA-02290: check constraint (APPS.SYS_C00207769) violated

if u create trigger
CREATE TRIGGER CHKT BEFORE INSERT ON T_CHK
FOR EACH ROW
BEGIN
IF :NEW.A >100 THEN
RAISE_APPLICATION_ERROR(-20011,'VALUES SHOULD BE < 100');
END IF;
END;

INSERT INTO T_CHK VALUES(101);

ORA-20011: VALUES SHOULD BE < 100
ORA-06512: at "APPS.CHKT", line 3
ORA-04088: error during execution of trigger 'APPS.CHKT'

if u don't create trigger then constraint will be first otherwise if u create trigger to the same table with same DML operations here trigger will fire first instead of constraint firing

What is a natural join?

1139

---

What does sign mean sql?

1177

---

What are the sql versions?

995

---

What are the subsets of sql?

1193

---

What are the two parts of design view?

1062

---

What are all different types of collation sensitivity?

1075

---

Can we insert data into materialized view?

989

---

Can there be 2 primary keys in a table?

1039

---

what are date and time data types in mysql? : Sql dba

1019

---

What is the most important ddl statements in sql are?

1042

---

What are tuples in sql?

1189

---

What is structural independence and why is it important?

1071

---

What is faster join or subquery?

1058

---

How can you fetch first 5 characters of the string?

1060

---

What is normalisation in sql?

1098

---