Answer Posted / gopi mandadi

Select emp_no,name,dept,sal from emp_t A
Where &n = (Select sal from emp_t B Where A.sal <= b.sal)

Explain different types of lock modes in sql server 2000?

521

---

How to use subqueries in the from clause in ms sql server?

568

---

What is a mixed extent?

595

---

Please explain go command in sql server?

598

---

What are the different authentication modes in sql server? How can it be changed?

567

---

---

What the class forname () does?

547

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

586

---

What is a db view?

519

---

Tell me about normalization in DBMS.

583

---

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

545

---

What is 1nf 2nf and 3nf?

493

---

Why and when do stored procedure recompile?

546

---

How do you drop an index?

503

---

What are joins in sql and what are the different types of joins?

551

---

Why is the need for data conversion transformations?

502

---