Answer Posted / sri

Experience

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

512

---

What is CTE in SQL

538

---

What are the different sql server versions?

515

---

What is ms sql server triggers?

535

---

How to link tables in sql server?

473

---

---

What is primary key, unique key, and foreign key?

536

---

Explain various data region available in ssrs with their use?

490

---

What is tcl in sql server?

663

---

What does executeupdate return?

537

---

Can we deploy SSRS reports on our personal website?

123

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

5764

---

What is a bit datatype?

560

---

Are all views updatable ?

720

---

What is dbcc? Give few examples.

574

---

Explain mixed authentication mode of sql server?

541

---