Answer / srinivas

Index is a database object which improves the efficiency of
the query

Answer / guest

When queries are run against a db, an index on that db
basically helps in the way the data is sorted to process the
query for faster and data retrievals are much faster when we
have an index.

Answer / uma

index is used to speed up query execution,indices are used
to locate the tables in the database.

What is difference between stored procedure and function?

3 Answers   L&T,

---

What is scheduled job and how to create it?

0 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

What is log cache in sql server?

0 Answers  

---

---

What is user-defined inline table-valued function?

0 Answers  

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

What are the operating modes in which database mirroring runs?

0 Answers  

---

Do you know what is lock escalation?

0 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

What is the server name in sql server?

0 Answers  

---