Answer Posted / rakesh

In Oracle

select marks from
(select marks from
(select marks from students order by marks desc)
where rownum<3
order by marks asc)
where rownum<2

What is raid? : SQL Server Architecture

598

---

What is public role in sql server?

540

---

What are partitioned views?

582

---

What is user defined datatypes and when you should go for them?

590

---

What is msdb database? : SQL Server Architecture

541

---

---

What are clustered and non-clustered index?

550

---

What is an expression in ms sql server?

573

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

549

---

How do I create a trace in sql server?

518

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

560

---

What is sql server 2000 work load governor?

556

---

What is a partitioned view?

574

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

487

---

Can we use pragma autonomous_transaction in trigger?

543

---

What is the use of keyword with encryption. Create a store procedure with encryption?

587

---