what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

Explain view in sql server?

0 Answers  

---

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

---

What is indexing a document?

0 Answers  

---

---

how to find 6th highest salary

0 Answers   Chetak Logistics,

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What is the system function to get the current user's user id?

2 Answers   HCL,

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

what purpose does the model database serve? : Sql server database administration

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

Explain optimistic and pessimistic concurrency?

0 Answers  

---