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...

hi..........i m Accenture employee...Accenture is an IT
company having itz branches in India at Mumbai, Pune,Delhi,
Hyderabad, Chennai and Bangalore....Presently there are
openings here for SAP, Testing, Oracle,Java,.NET,MAinframe
and Peoplesoft...... I am a software engineer working with
Accenture,Mumbai....u can mail me in your resume..i`ll
forward it to our HR team...my mail id:
pankit.lodaya@accenture.com

Answer Posted / srikanth

When we are doing the frequent updates to the columns which
we built the index on the column then the index on that
column is non meaning ful because the index should rebuilt
every time the updation were happen.

we should create index on the columns which we use
frequently in the WHERE clause.

If we dont close the cursor also we do not get any error
the procedure will be executed succesfully but if we close
the cursor the private SQL work area allocated to the
cursor will be relased.

Is This Answer Correct ?    17 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the different case manipulation functions in sql?

1001


Does sql backup shrink transaction log?

954


What is the purpose of the primary key?

1050


What is sql profiling in oracle?

1041


What is the use of sqlerrd 3?

927


What does dml mean?

965


Can we insert delete data in view?

935


Does sql between include endpoints?

989


How do you drop a trigger?

967


What are all the different types of indexes?

1126


Explain the working of primary key?

1074


What is procedure and function in sql?

975


what is recursive stored procedure? : Sql dba

971


Explain the steps needed to create the scheduled job?

1023


What is triggering circuit?

1050