What is the Diff b/w Constraints and Trigeer

Answer Posted / manoranan sethy

Constraints are restrict the invalid data before invoke into the database whereas trigger restrict the invalid transaction.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does varchar include?

520


What is difference between function and trigger?

546


If a cursor is open, how can we find in a pl/sql block?

679


What is partition by in sql?

574


Does view store data in sql?

540






What is difference between mysql and postgresql?

520


What is assignment operator in pl sql?

572


Which one is better sql or oracle?

505


What is a unique key?

588


Which command is used to call a stored procedure?

505


What will you get by the cursor attribute sql%notfound?

595


What are sql commands?

505


How do I install microsoft sql?

531


Why truncate is faster than delete?

567


what is the difference between inner and outer join? Explain with example. : Sql dba

553