Why INTEGRITY CONSTRAINT are better to validate data in a table than to STORED PROCEDURE ?
Options
- Because the stored procedure occupies more space in the database than a integrity constraint definition
- Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked
- Because a stored procedure creates more network traffic than a integrity constraint definition
CORRECT ANSWER : Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked
Write your comments