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
- 8 Answers
- 37265 Views
- Wipro, I also Faced
- E-Mail Answers
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
What is duration in sql profiler trace?
Explain the difference between triggers and constraints?
What are sql procedures?
Can a select statement fire a trigger?
What is mutating trigger?
What is the difference among union, minus and intersect?
What is the difference between join and natural join?
What is field delimiter?
Explain the types of joins in sql?
What is difference between left and right outer join?
what is the syntax for using sql_variant_property? : Transact sql
discuss about myisam key cache. : Sql dba
What is the difference between the sql*loader and import utilities? : aql loader
How does left join work in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
