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
- 35783 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 if we write return in procedure?
Can there be more than one function with a similar name in a pl/sql block?
How do I copy a table in sql?
Explain what is rdbms?
Why functions are used in sql?
How to select 10 records from a table?
How many clustered indexes can you have?
What is cross join sql?
What do you mean by rowid?
explain advantages of myisam over innodb? : Sql dba
what are the 'mysql' command line options? : Sql dba
How do I sort a table in sql?
what is a field in a database ? : Sql dba
What are the built in functions of sql?
How do you rank data in sql?
