Answer / Antul Awashthi

"Scan Table/View": A full scan or table scan is a data retrieval operation in SQL Server where every row of the table or indexed view is read to satisfy a query. It's used when an index isn't available, or the query requires access to unindexed columns.

"Seek Table/View": A seek operation in SQL Server is a data retrieval method that uses an index to find specific rows quickly without reading all the rows of the table or view. The database engine only reads the pages where the matching key values are found."

What is application role in sql server database security? : sql server security

1 Answers  

---

What are the differences between clustered and non-clustered index?

1 Answers  

---

How to delete an existing row with delete statements in ms sql server?

1 Answers  

---

What are the steps you can take to avoid “deadlocks”?

1 Answers  

---

last function used in MS Access to convert sql what function will use in sql

1 Answers   Cap Gemini,

---

Can we update data in a view?

1 Answers  

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---

How to find table changes in sql server?

1 Answers  

---

How to create an multi-statement table-valued function?

1 Answers  

---

What authentication modes does sql server support?

1 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

What is a NOLOCK?

3 Answers   NA,

---