Answer Posted / naga

log shipping:
1)backup job
2)copy job
3)restore job
4)alert job




database mirroring
1)database mirroring monitor job



replication
1)agent history cleanup job
2)distribution clean job
3)expire subscription clean job
4)replication agent checkup job
5)replication monitor refresh for distributor
6)reinitialize subscriptions having data validation failures

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1016

---

What is ssl in sql server?

1090

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

956

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1046

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1033

---

How to see existing views in ms sql server?

1057

---

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? : Sql server administration

987

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1037

---

What is the current pricing model of SQL Azure?

104

---

Explain the architecture of ms sql reporting service?

934

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

997

---

How does recursive cte works in sql server?

1024

---

What is query and its types?

927

---

Can you please explain the difference between primary keys and foreign keys?

1129

---

Explain important index characteristics?

1048

---