Answer Posted / raghuram

Replication is a process of copying/moving data between
databases on the same or different servers.In Replication,
We have Three server.
a) Publisher : It is the Principal server
b) Distributor : It sends the data from
Publisher to Subscriber
c) Subscriber : It is the secondary server
which stores the received data
The types of Replication are,
a) Snapshot Replication : It distributes data
exactly as it appears at a specific moment in time and does
not monitor for updates to the data. It is the best used
method of replicating data that changes infrequently or
where the most up-to-date values are not requirement. When
synchronization occurs, the entire snapshot is generated
and sent to the subscribers.
b) Merge Replication : It is the process of
distributing data from Publisher to subscriber, allowing
the Publisher and Subscriber to make update data while they
are connected or disconnected, and then merging the updates
between sites when they are connected.
c) Transactional Replication : An initial snapshot
of data is applied to subscriber, and when data
modifications are made at the publisher, the individual
transactions are captured and propogated to subscriber.

Explain what are the database objects? : SQL Server Architecture

1055

---

How to list all user names in a database?

1035

---

How to create a new table in a given schema?

1164

---

Explain view in sql server?

1041

---

Explain the difference between HTTP and HTTPS in database?

1010

---

What is compound operators?

1028

---

How do you trace the traffic hitting a sql server?

1119

---

Why use cursor in sql server?

1059

---

What are the parts of a function?

916

---

List the data types available in mssql?

1015

---

What is sql server programming?

1020

---

How is SQL Azure different than SQL server?

223

---

Describe in brief sql server monitoring ways.

1033

---

Which tcp/ip port does the sql server run on? How can it be changed?

1031

---

Is mysql the same as sql server?

957

---