Answer / Suresh Kumar Singh

Sybase IQ offers several advantages such as extreme scalability, high performance for complex queries, and the ability to handle large volumes of data. It's optimized for data warehousing and business intelligence applications, with features like column-oriented storage, adaptive query processing, and compression technology.

Why do my page locks not get escalated to a table lock after 200 locks?

1 Answers  

---

Explain data cache?

1 Answers  

---

What is the command for quitting from sybase?

1 Answers  

---

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

1 Answers  

---

How would you fix a munged log in sybase ?

1 Answers  

---

Explain sybase sql server?

1 Answers  

---

What is a temp table? how to denote temp table?

4 Answers   Oracle,

---

How to compute database fragmentation in sybase?

1 Answers  

---

Differentiate between ltm and repagent?

1 Answers  

---

Why place tempdb and log on low numbered devices?

1 Answers  

---

Explain procedure cache?

1 Answers  

---

Differentiate between clustered and non-clustered index.

1 Answers  

---