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

You need to purge data from audit database. What will you do?

891

---

How do check the current running processes?

954

---

Who owns sybase?

845

---

What do you mean by sybase iq?

898

---

What is the difference between replication server and sql remote in sybase?

940

---

Differences between clustered and non-clustered in sybase?

888

---

What is the default size of master database in sybase?

921

---

Explain index covering?

833

---

How do I open a sybase database?

981

---

Explain intimate shared memory(ism)

906

---

How do I tell which tables have identities in sybase?

873

---

What is this tds protocol in sybase?

957

---

Explain defncopy and it's usage?

971

---

How would you check the long running transaction?

914

---

What is a natural key in sybase?

1042

---