Answer Posted / vinayak

select empid,empname from employee

What is delete query?

894

---

Where is localdb stored?

884

---

What is the latest version of microsoft sql server?

955

---

What is an example of a primary key?

909

---

What are the different types of replication you can set up in sql server?

980

---

How can we rewrite sub-queries into simple select statements or with joins?

919

---

What is difference between count (*) and count 1?

862

---

How to create a ddl trigger using "create trigger" statements?

1064

---

What are relationships and mention different types of relationships in the dbms

908

---

Define outer join in sql server joins?

889

---

Explain what is sql server english query?

984

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

962

---

What is resource governor?

925

---

How can you ensure that the database and sql server based application perform well?

1010

---

What is transaction server isolation?

973

---