Answer Posted / chitram

select e1.sname,e2.sname from emp e1,emp e2 where e1.sname
= 'ram'
and e2.sname = 'raj';

How many non clustered indexes there can be on table ?

503

---

What is standby servers? Explain types of standby servers.

503

---

What is the purpose of sql profiler in sql server? : sql server database administration

617

---

Define inner join in sql server joins?

531

---

What are constraints?

576

---

---

What is code near application topology?

197

---

Explain acid?

599

---

How to get the number of affected rows?

551

---

Do you know what are the restrictions that views have to follow?

616

---

How to get all stored procedures in sql server?

501

---

explain extended properties

556

---

What is a view in sql?

570

---

Explain what are the database objects? : SQL Server Architecture

556

---

What is sql language?

544

---

What is mapping schema?

565

---