Sybase Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Sybase Interview Questions

Questions Answers Views Company eMail

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

FIC,

3 8703

What will happen if we create more indexes on a sysbase iq table?

1 7279

What are Magic Tables?

TCS,

4 11800

How can we add a column to a table without altering the same?

BNP Paribas,

4 22223

How can i retrieve the pseudoColumn values of a table in sybase? In oracle, we can get the same as 'ROWID'. Likewise in sybase which one is pseudo column?

1 6835

How to connect sybase server with unix.

HCL,

3 8381

What are different performance tuning tools in sybase with example. How to optimize sql code in sybase server.

Polaris,

1 7196

What is the depth of triggers?

982

Explain the structure of adaptive server enterprise?

897

Why am I running out of locks on the replicate side in sybase ?

1018

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

951

What is ceiling()?

979

what is update statistics in sybase?

1165

What command helps you to know the process running on this port, but only su can run this command?

919

Compare join and subquery in performance?

962

Post New Sybase Questions

Un-Answered Questions { Sybase }

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?

897

Explain intimate shared memory(ism)

908

What command helps you to know the process running on this port, but only su can run this command?

919

Why am I running out of locks on the replicate side in sybase ?

1018

You want to delete a table in sybase. How would you do it?

855

How would you list objects in sybase?

976

Explain update statistics.

862

Can you create your own sps for system wise?

913

What is the default size of master database in sybase?

921

How do I exclude a column in sybase?

899

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

907

What you need to do is issue an ase kill command on the connection then un-suspend the db?

938

Why do my page locks not get escalated to a table lock after 200 locks?

870

Differentiate between replication server and sql remote?

971

How can I tell the datetime my server started?

969

For More Un-Answered { Sybase } Questions Click Here