Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is heap table?

1078


What data type is money?

912


What is an example of a delimiter?

981


What are procedures in mysql? Explain

1030


What is insert query in mysql?

956


What sql does mysql use?

1000


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4720


How do I use mysql?

937


How to returns the columns and column information pertaining to the designated table.

1077


What is mysql aggregate functions? Explain

1165


How would you enter characters as hex numbers?

991


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 ?

2190


What are the critical issues you have resolved in your company

2318


How do you flush privileges?

1022


Is there a way to see the files which are stored?

1015