Answer Posted / prashant

when temp db gets filled
that means there are large number of open process that are
making log of temp db ful in this case we wont even able to
run sp_who
what we will do is :
lct_admin('abort',0,2)
it will kill all open transactions but still log remains
full
now we will alter & extend the database

Explain locking. List its types.

854

---

How do I set ts role in order to run certain dbccs?

733

---

Explain the difference between numeric and decimal data types in sybase.

815

---

When should I execute an sp_recompile in sybase?

822

---

How do you view log files in sybase?

896

---

What will you do if a replication thread goes down?

918

---

How would you lock a table in sybase?

889

---

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

876

---

Can I run any transact-sql command on a partitioned table in sybase?

784

---

How to implement if-then-else in a select clause in sybase?

746

---

List the types of locking?

925

---

How do I create a database in sybase central?

841

---

Explain relationship between jdbc and sybase.

844

---

Explain tds (tabular data streams).

844

---

Differentiate between db-lib and ct-lib?

900

---