Sybase Interview Questions

How to stop Sybase(ASE) Server?

1> shutdown RUN_Servername
2> go

How to stop Sybase backup server?

1> shutdown SYB_BACKUP
2> go

How to start Sybase ASE server?

To start the server Sybase ASE server, navigate to …./ASExxx/install/. Then, run following command
1> startserver –f RUN_servername
2> go

How to start Sybase Backup server?

To start the server Sybase backup server, navigate to …./ASExxx/install/. Then, run following command
1> startserver –f RUN_servername_back
2> go

How to stop Sybase ASE server forcefully?

1>shutdown with no wait
2>go

How to find out who initiated shutdown command in Sybase?

This can be checked from errorlog. To check that, run the following command, it will give the log name. Then check the last lines of the log.

1> select @@errorlog
2> go

What will happens when we run “shutdown with no wait”?

It disables the logins, does not issue checkpoint, and it terminates current transactions (processes).

What are the different roles available in Sybase?

There are six roles available in sybase.
sa_role
sso_role
oper_role
sybase_ts_role
navigator_role
replication_role
dtm_tm_role
ha_role
mon_role
js_admin_role
messaging_role
js_client_role
js_user_role
webservices_role
keycustodian_role
sa_serverprivs_role

How to check the last update statics performed date?
select moddate from sysstatistics where id=object_id(“accounts”)

Will be added some more questions soon.

CheapSexCams
Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: