Answer / Snigdha Jauhari

No, you cannot perform a regular backup or restore operation on the tempdb database in SQL Server. Tempdb is automatically managed by SQL Server and does not need to be backed up or restored like user databases.

What do you mean by an execution plan? How would you view it?

1 Answers  

---

Explain what you mean by 3 tier architecture.

1 Answers   TCS,

---

What is the difference between clustered and a non-clustered index?

1 Answers   NA,

---

What is the difference between delete and truncate statements?

1 Answers  

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1 Answers  

---

What are the different types of replication are there in sql server 2000?

1 Answers  

---

What is the stored procedure?

1 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

What does REVERT do in SQL Server 2005?

1 Answers   HCL,

---

How make remote connection in database?

1 Answers  

---

What are the advantages of paper records?

1 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---