Answer Posted / vikash kumar mishra

There are five type of cursors in SQL server.
1)Base table:- This is lowest level cursor.

2)Static :- This is scrollable query cursor in earlier
versions of SQL Server Compact Edition

3)Forward-only:- The forward-only cursor is the fastest
cursor that you can update, but it does not support
scrolling.

4)Forward-only/Read-only:- Forward-only/read-only cursors,
referred to as forward-only cursors in earlier versions of
SQL Server Compact Edition, are the fastest cursors, but
cannot be updated.

5)Keyset-driven:- The keyset-driven cursor in SQL Server
Compact Edition is a scrollable cursor that you can update.
A keyset-driven cursor is controlled by a set of physical
identifiers known as the keyset.

Should you normalize audio?

531

---

Explain what are various ways to enhance the ssrs report?

572

---

Can we use pragma autonomous_transaction in trigger?

543

---

Difference between primary key and clustered index?

505

---

What is the command used to recompile the stored procedure at run time?

625

---

---

What is the main purpose of having conversation group?

498

---

What is a domain constraint give an example?

565

---

What are the properties of primary key?

519

---

What are a scheduled jobs?

536

---

Do you know what is rank function?

627

---

What is ms sql server triggers?

540

---

What is page-level compression?

558

---

Can a table be created inside a trigger?

566

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

571

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

553

---