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
How to change the order of columns in Oracle SQL Plus ?
Can we use delete in merge statement?
Explain the rollback statement?
What is pl/sql language case sensitive?
Why do we need view in sql?
How to read/write files from pl/sql?
Which is better varchar or nvarchar?
How much does sql cost?
Does sql*plus also have a pl/sql engine?
What does := mean in pl sql?
How to sort the rows in sql.
Can a table have no primary key?
What is db journal file?
How many scalar data types are supported in pl/sql?
Is record in oracle pl sql?