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 7601

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

1 6525

What are Magic Tables?

TCS,

4 10223

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

BNP Paribas,

4 20620

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 6146

How to connect sybase server with unix.

HCL,

3 7073

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

Polaris,

1 6314

What is the depth of triggers?

506

Explain the structure of adaptive server enterprise?

486

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

526

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

491

What is ceiling()?

548

what is update statistics in sybase?

635

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

488

Compare join and subquery in performance?

558


Post New Sybase Questions

Un-Answered Questions { Sybase }

Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?

455


What is replication server?

524


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?

501


What is difference between sybase and oracle?

471


Explain coalesce.

498






Explain open server?

491


How would you check the long running transaction?

482


What is the drawbacks of normalization?

559


How can set the multipal database ?

2456


What are the different types of (all page) locks in sybase?

441


Does sybase support row level locking?

446


List different types of locks in sybase?

513


What is server replication?

491


Does table partitioning require user-defined segments in sybase?

412


Explain about the mainframe connect tools from sybase?

470