Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
Database Optimization Tutorial
→
Database Optimization Interview Questions in Database Optimization Tutorial
→
What Are The Ways To Code Efficient Transactions?
1.
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.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
What Are Indexes?
Tell Me What Are The Types Of Indexes?
Explain In Brief The Cursor Optimization Tips?
Explain Execution Plan?
Explain Some Disadvantages Of The Indexes?
Do You Know What Are The Ways To Code Efficient Transactions?
What Are The Ways To Code Efficient Transactions?
Tell Me What Is Index Tuning?
How Is Index Tuning Used To Improve Query Performance?
Tell Me In Brief The Cursor Optimization Tips?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies