Answer Posted / prabhu

Databases per Adaptive Server Enterprise - 32,767
Server Size - 8 terabytes
Database size - 4 terabytes
Page Size - 2K, 4K, 8K, 16K
Databases spanned by one update 16
Databases opened by one transaction 16
Tables in a query 50
Logins per server 2,147,516,416
Users per database 2,146,484,223
Groups per database 1,032,193
Columns per table 1024
Arguments to stored procedure 2048

What is a good example of a transaction in sybase?

1109

---

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

927

---

How do I configure identities in sybase?

917

---

What are the catches?

941

---

Differentiate between db-lib and ct-lib?

1022

---

Explain the advantages of data integration suite in sybase.

929

---

How would you lock a table in sybase? What text command will you use for it?

938

---

Can I run any transact-sql command on a partitioned table in sybase?

893

---

What is the command for quitting from sybase?

978

---

How to start sybase database in windows?

1198

---

How do you view log files in sybase?

985

---

What are the main differences between 11.x and 12.x versions of sybase?

884

---

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

921

---

Explain table partitioning in sybase.

972

---

How to clear tempdb when the tempdb gets filled in sybase?

887

---