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
Which are the different case manipulation functions in sql?
Does sql backup shrink transaction log?
What is the purpose of the primary key?
What is sql profiling in oracle?
What is the use of sqlerrd 3?
What does dml mean?
Can we insert delete data in view?
Does sql between include endpoints?
How do you drop a trigger?
What are all the different types of indexes?
Explain the working of primary key?
What is procedure and function in sql?
what is recursive stored procedure? : Sql dba
Explain the steps needed to create the scheduled job?
What is triggering circuit?