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 do I connect to sybase?

881

---

What is the command for quitting from sybase?

939

---

Explain the structure of adaptive server enterprise?

901

---

You need to multiply all values of a single column. How would you do that?

893

---

Explain locking?

913

---

What is the use of 'with check' option in views?

907

---

You need to manipulate varbinary columns in sybase. How would you do that?

971

---

How to restore sybase database in sap?

972

---

How do I choose which tables to partition in sybase?

874

---

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

858

---

How do I turn off marked suspect on my database in sybase?

890

---

Using large raw partitions with replication server on unix in sybase?

967

---

Explain relationship between jdbc and sybase.

916

---

Explain update statistics.

865

---

Are there any alternatives to isql in sybase?

943

---