Answer / Vikas Deep

{n "structure": "A multi-tiered architecture consisting of client applications, middleware (InterActive SQL), and database servers",n "components": [n {"name": "Client Layer", "description": "Provides user interfaces for accessing the system"},n {"name": "Middleware Layer", "description": "Facilitates communication between clients and servers, and provides additional services like security and replication"},n {"name": "Database Server Layer", "description": "Manages data storage and retrieval operations"}n ]n}

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

4 Answers   Oracle,

---

The secondary truncation point is on. How would you clear the logsegment?

1 Answers  

---

Differentiate between ltm and repagent?

1 Answers  

---

Explain locking. List its types.

1 Answers  

---

Explain index covering?

1 Answers  

---

Differentiate between db-lib and ct-lib?

1 Answers  

---

what is the architechure of sybase ASE?

2 Answers   ocbc,

---

Explain about the features of sybase iq?

1 Answers  

---

Differentiate between clustered and non-clustered index.

1 Answers  

---

What command helps you to know the process running on this port, but only su can run this command?

1 Answers  

---

How can you change to get the decimal separator as comma instead of the decimal point (.)?

1 Answers  

---

How would you improve throughput in sybase?

1 Answers  

---