Why is it better to use an Integrity Constraint to validate
data ?
Answer Posted / guest
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
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain the architecture of reporting services?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What is data sublanguage?
How index hunting contributes in improving the query performance?
What is a database management system and give examples?
Explain the components of rdbms?
What is executive plan?
Compare non-clustered and clustered index
What is data redundancy in dbms?
What is database normalization with example?
How do you backup a database?
Explain dml (data manipulation language)?
What's the difference between delete and truncate ?
What is the purpose of normalisation?
What do you understand by query optimization?