I had covered set of interview questions earlier( Important 15 Sybase ASE DBA Interview Questions and Answers) and it was liked by our DBA community and have got feedback to cover few more questions and a bit challenging ones. I have compiled list of a bit tricky questions and I am sure you would like them as they are competitive and will test overall your experience as well as your approach to answer them:
Below are set of questions:
- What is spinlock contention
- Difference between Spinlock, Latch and Table Lock
- What is Row Forwarding in Sybase
- What is deferred update and when it is required
- Difference between Direct Update & Deferred Update
- In the execution plan, you see – QUERY PLAN IS RECOMPILED DUE TO TABMISSING. THE RECOMPILED QUERY PLAN IS: What is the meaning?
- In the execution plan, you see – QUERY PLAN IS RECOMPILED DUE TO SCHEMACT. THE RECOMPILED QUERY PLAN IS: What is the meaning?
- How to perform In place upgrade of Sybase ASE and do migration of user database
- What is Safer and faster way to upgrade Sybase
- How to perform In place upgrade of Sybase Replication
- How to list top 10 CPU intensive process
- Host to list top 10 Physical IO intensive processes
- Difference between Logical IO and Physical IO
- How do you list all the configuration which is not set at default? Meaning has been changed
- How to check the status for all configurations
I have posted video with answers on all above questions at my YouTube channel, you may refer them and let me know your feedback: