Answer Posted / gagan

Self join correlated rows of a table with other rows in the
same table.

Eg:
select a.name+'issue the book= '+b.book form lib a,lib b
where rollno between 1 and 10

What is a DBMS, query, SQL?

1095

---

How each E-R model constructs can be mapped to the relational model?

1052

---

What is right outer join in sql server joins?

1221

---

What is the difference between char and varchar2 datatype in sql?

1125

---

What are the different index configurations a table can have?

1011

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1030

---

What is a data source or ds? : sql server analysis services, ssas

1053

---

Why normalization is used?

1069

---

Explain about Views?

1127

---

What command is used to create a database in the sql server and how?

1243

---

A trigger can reference objects outside the current database? State true or false.

1061

---

How do I get to sql server configuration manager?

1062

---

Can I delete event logs?

979

---

How do I connect to sql server database?

1069

---

What is the importance of three tier architecture?

1143

---