Sybase interview questions


Ø What is sybase?

Ø Explain ASE architecture?

Ø What are the system roles ?

Ø What are the default databases ?

Ø Threads inside Sybase?

Ø what is time slice error and how to resolve timeslice -201 ?

Ø what is fill factor?

Ø Types of locks in Sybase?

Ø Row locking mechanism in ASE?

Ø what is the use of data cache,procedure cache,statement cache?

Ø Truncate only and no log difference?

Ø Dirty buffers?

Ø Reorg types ?

Ø Types of update statistics and how to check the last stats of the table?

Ø How to clear tempdb space ?

Ø How to separate tempdb from master ?

Ø How to check long running queries?

Ø What is the use of sybsystemdb?

Ø Clustered index and non clustered index ?

Ø Table partitions and its use ?

Ø What is the threshold actions ?

Ø what is the use of sysmon report?

Ø what is optdiag report ?

Ø How to run upgrade?

Ø What is zombie/ghost process?

Ø What is RAID in sybase ?

Ø Different types of replication and how to configure and maintain high availability?


Refer the below links for more :

https://testmydailyworks.wordpress.com/2012/11/28/sybase-all-in-one/

https://dbasdiary.com/home/important-15-sybase-ase-dba-interview-questions-and-answers/

https://www.bestinterviewquestion.com/sybase-interview-questions

https://www.wisdomjobs.com/e-university/sybase-interview-questions.html

http://dba.fyicenter.com/Interview-Questions/SYBASE/

https://www.globalguideline.com/interview_questions/Questions.php?sc=sybase_database

https://www.careerride.com/sybase-interview-questions.aspx

 



Sybase history

Sybase  is a computer software company that develops and sells database management system (DBMS) and middleware products. The company was fo...