You need to purge data from audit database. What will you do?
Tempdb is full. How would you clear it?
What mandatory options are required for bcp command utility?
Explain coalesce.
You need to remove the affected rows and dashes. How would you do that?
Explain update statistics.
How would you lock a table in sybase?
You need to multiply all values of a single column. How would you do that?
What is the role of replication server in sybase?
You need to manipulate varbinary columns in sybase. How would you do that?
explain engines?
Explain bind cache?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
Explain relationship between jdbc and sybase.
You need to remove duplicate rows from a sybase table. How would you do that?