- World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.

  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!

    Send your Resume to 6000 Companies

    Question :
    Optimistic versus Pessimistic locking in Sybase?
    Category Sybase Interview Questions
    Rating (0.2) By 125 users
    Added on 7/1/2011
    Views 393
    Rate it!

    Solution #1
    Use a timestamp on a header table that would be shared by the common data. This timestamp field is a Sybase datatype and has nothing to do with the current time. Do not attempt to do any operations on this column other than comparisons. What you do is when you grab data to present to the end-user, have the client software also grab the timestamp column value. After some thing time, if the end-user wishes to update the database, compare the client timestamp with what's in the database and it it's changed, then you can take appropriate action: again this is dictated by the business.

    Problem #1
    If users are sharing tables but columns are not shared, there's no way to detect this using timestamps because it's not sufficiently granular.

    Solution #2
    ... Also are you coding to ct-lib directly? If so there's something that you could have done, or may still be able to do if you are using cursors.

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

    Related Questions
    View Answer
    How do I force an index to be used in Sybase?
    View Answer
    Why place tempdb and log on low numbered devices?
    View Answer
    Should I run 32 or 64 bit ASE with Solaris?
    View Answer
    What is Intimate Shared Memory or ISM?
    View Answer
    How do I set TS Role in order to run certain DBCCs?
    View Answer
    Differences between clustered and non-clustered in Sybase?
    View Answer
    How do I capture a process s SQL in Sybase?
    View Answer
    What are the catches?
    View Answer
    What is CIS and how can I use it?
    View Answer
    If the master device is full, how do I make the master database bigger?
    View Answer
    What is cmaxpktsz good for in Sybase?
    View Answer
    What is Trace Flags -- 5101 and 5102 in Sybase?
    View Answer
    How to clear a log suspend?
    View Answer
    How to Shrink a Database?
    View Answer
    How do I audit the SQL sent to the server?
    View Answer
    What is the best value for cschedspins?
    View Answer
    What is Trace Flag Definitions in Sybase?
    View Answer
    How do I run multiple versions of Sybase on the same server?
    View Answer
    How do I turn off marked suspect on my database in Sybase?
    View Answer
    On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
    View Answer

    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here - Best Freshers & Experienced Jobs Website.

    View ALL Sybase Interview Questions

    User Options
    Sponsored Links

    Copyright ©2003-2015, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes

    Cache = 0.046875 Seconds