What are the advantages of stored procedures, triggers,
indexes?
Answer Posted / riyas_isno
Triggers are used to identify changes (like insert,update
or delete) in database tables and captured in temp tables
seperately....it helps in business level logics...
procedures contains group of sql statements which are
precompiled ones.....
indexes helps in speedup our execution...
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is heap table?
What data type is money?
What is an example of a delimiter?
What are procedures in mysql? Explain
What is insert query in mysql?
What sql does mysql use?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
How do I use mysql?
How to returns the columns and column information pertaining to the designated table.
What is mysql aggregate functions? Explain
How would you enter characters as hex numbers?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What are the critical issues you have resolved in your company
How do you flush privileges?
Is there a way to see the files which are stored?