Answer Posted / rinu

Triggers can nest to a depth of 16 levels. The current
nesting level is stored in the @@nestlevel global variable.
Nesting is enabled at installation. A System Administrator
can turn trigger nesting on and off with the allow nested
triggers configuration parameter.
the same is applied for Sp with nesting level with a range
or depth from 0 to 16.
if more than 16 then we get an error as :Maximum stored
procedure nesting level exceeded (limit 16).

List different types of sybase index.

831

---

What are the important features of sybase?

917

---

What is the use of sp_helprotect in sybase?

912

---

How would you lock a table in sybase? What text command will you use for it?

826

---

What are the advantages that you can get from mainframe connect in sybase?

816

---

What is cis and how can I use it?

1002

---

State some of the criticism about sybase iq?

866

---

What is replication in sybase?

841

---

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

798

---

Explain procedure cache?

899

---

Which version of open client works with which ase in sybase?

868

---

What is trace flags — 5101 and 5102 in sybase?

870

---

Explain about the sybase group?

865

---

What is coalesce in sybase?

897

---

Differentiate between clustered and non-clustered index.

841

---