SYBASE TUTORIALS: 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 :

SYBASE TUTORIALS