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

between cast and convert which function would you prefer and why?

956

---

What are the different types of sub-queries?

1044

---

Do you know what are various aggregate functions that are available?

1127

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1023

---

Do you know the isolation level that sql server support?

961

---

wat wil hapn if we give the both read and deny read permission to user?

2103

---

ow to bring suspect mode datbase online from scratch

1806

---

Tell me what is the stuff and how does it differ from the replace function?

981

---

what is spatial nonclustered index

992

---

How many levels of sp nesting is possible?

1056

---

Does a full backup include transaction log?

976

---

What the class forname () does?

1065

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1045

---

Explain sub-query?

958

---

What is advantage data architect?

925

---