Answer Posted / dataarchitect

1. Compression levels are used during either full or log
backups.
2. O is lowest compression level while 9 is highest
compression level
3. Just keep in mind while deciding about compression level
higher compression level will cause max. cpu utilization
and may affect performanc of syste, especially for big db.
4. ASE 15** comes up with new compression levels i.e. 100
and 101 . sybase claims that these are fastes and use less
cpu...

How does sybase replication work?

833

---

What is raid and sybase?

872

---

Explain the features of sybase.

864

---

What is difference between sybase and oracle?

880

---

Explain about the sybase group?

860

---

Explain timestemp datatype in sybase.

901

---

What are the best monitoring tools for the sybase database?

761

---

Explain index covering?

793

---

How would you replicate col = col + 1 in sybase?

986

---

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

879

---

Explain defncopy and it's usage?

907

---

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

877

---

Explain table partitioning in sybase.

854

---

What is the default size of master database in sybase?

871

---

What is server replication?

906

---