Answer / Shuchita Joshi

In Sybase, you can connect to multiple databases using the ISQL (Interactive SQL) tool. To do this, you need to create a connection profile for each database and then use the CONNECT command to switch between them. Alternatively, you can use Transact-SQL's OPEN and CLOSE statements within a stored procedure or trigger.

What is the difference between natural join and equi join?

1 Answers  

---

Explain data cache?

1 Answers  

---

How do you view log files in sybase?

1 Answers  

---

What are the operating systems in which sybase could take its presence?

1 Answers  

---

Explain index covering? List its merits.

1 Answers  

---

What are the different types of (all page) locks in sybase?

1 Answers  

---

How do I make isql secure in sybase?

1 Answers  

---

How would you check the long running transaction?

1 Answers  

---

Must I use multiple devices to take advantage of partitions in sybase?

1 Answers  

---

Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

1 Answers  

---

What is this tds protocol in sybase?

1 Answers  

---

What will happen if we create more indexes on a sysbase iq table?

1 Answers  

---