In this article, we are going to discuss the Sybase Interview Questions and Answers.
1) How to stop Sybase Server forcibly.
shutdown with nowait
2) What is the query to check blocking in blocking?
select spid,cmd,staus,physical_io,blocked from master..sysprocesses where blocked>0
3) How to execute sybase script from linux
isql -Uuser_name -i input_filename -o output_filename
4) What is the query used to get list temporary databases in Sybase?
sp_tempdb show
5) What is query to get sql text of process id?
dbcc traceon(3604) go dbcc sqltext(spid) go
6) What is the difference between truncate_only and no_log?
dump tran dbname with truncate_only is used when we want to truncate the transaction log without actually creating a dump.
dump tran dbname with no_log is to be used to truncate the log without writing a checkpoint record to the log; this is necessary when the log fills up.
7) What are the list of dboption’s available in Sybase?
abort tran on log full
allow incremental dumps
allow nulls by default
allow wide dol rows
async log service
auto identity
dbo use only
ddl in tran
deallocate first text page
deferred table allocation
delayed commit
enforce dump tran sequence
erase residual data
full logging for all
full logging for alter table
full logging for reorg rebuild
full logging for select into
identity in nonunique index
no chkpt on recovery
no free space acctg
read only
scratch database
select into/bulkcopy/pllsort
single user
trunc log on chkpt
trunc. log on chkpt.
unique auto_identity index
8) How to keep Sybase server in single user mode?
startserver -m -frunserver_filename