Answer / Shailendra Gautam

The primary difference between last_name varchar(50) and last_name varchar(255) is the maximum length of the last_name variable. If you know that the length of the last names in your database will not exceed 50 characters, using a smaller data type such as varchar(50) can save storage space and improve performance. However, if there's a possibility that some last names might be longer than 50 characters, it's better to use a larger data type like varchar(255) for flexibility.

What is the timestamp datatype in sybase?

1 Answers  

---

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

1 Answers  

---

Which should I use, repagent or ltm in sybase?

1 Answers  

---

Explain index covering?

1 Answers  

---

What is replication server?

1 Answers  

---

Explain about the features of sybase iq?

1 Answers  

---

What is rollback trigger in a trigger?

1 Answers  

---

What is the command for quitting from sybase?

1 Answers  

---

Differentiate between replication server and sql remote?

1 Answers  

---

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

1 Answers  

---

What is the difference between db-lib and ct-lib in sybase?

1 Answers  

---

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

2 Answers   L&T,

---