Oracle DB Optimization Question:
Download Job Interview Questions and Answers PDF
Do you know what are the ways to code efficient transactions?
Answer:
We shouldn't allow input from users during a transaction.
We shouldn't open transactions while browsing through data.
We should keep the transaction as short as possible.
We should try to use lower transaction isolation levels.
We should access the least amount of data possible while in a transaction.
We shouldn't open transactions while browsing through data.
We should keep the transaction as short as possible.
We should try to use lower transaction isolation levels.
We should access the least amount of data possible while in a transaction.
Download Oracle Database Optimization Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me in brief the cursor optimization tips? | Explain Execution Plan? |