What command do we use to rename a db?

5 Answers   IBM,

---

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

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

Can you explain the role of each service?

1 Answers  

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---

What is the bookmark lookup and rid lookup?

0 Answers  

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---