I thought of doing another session for Sybase ASE DBA interview Questions and Answers inline with SQL Server DBA interview Questions and Answers and share with you. These questions are of expert levels and check your overall understanding as well as troubleshooting of SAP Sybase ASE database and approach towards solving issues. Interview typically lasts for 20-40 minutes, nobody can find everything about candidate however these questions and their answers could help in finding whether DBA is having good experience and has good problem solving technique.
Below are set of questions that are covered in this session:
- How to speed up database backup process? Please suggest 3 options
- How many types of Backups are there? Pre-requisites for them?
- How to find access level for a user or user object?
- What is the difference between SA Role and SSO Role?
- Give few Examples SA Role can’t do & SSO Role can do
- Difference between Login, User and Alias
- Explain about User Defined Role & Usage
- You issue backup command of a database but nothing happens, what to check?
- Command to check whether Sybase ASE service is up & running or not on Unix Server
- You have Full, Cumulative and Tran Backup configured, Noticed Tran Backup is on Increasing Path and not reducing. What to check?
- How do you find wait events? One which is max at your server?
- How to find when your Sybase service was last started?
- How to check Cache Configuration of your server?
- How to check Thread Configuration?
- List Few Maintenance Jobs where Downtime is not required & others
- Bonus Question – How to Transfer Logins from Primary to Secondary Server
I have covered above questions along with answers in my video:
This video has all the questions and their answers however if you would like to get a readily available handbook in the printable format(PDF) with more details, you may buy it at a very nominal price: