Answer / meeran

Replication is the process of sharing data between
databases in different locations. Using replication, we can
create copies of the database and share the copy with
different users so that they can make changes to their
local copy of database and later synchronize the changes to
the source database.

Microsoft SQL Server 2000 supports the following types of
replication:

Snapshot Replication
Transactional Replication
Merge Replication

Answer / 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.

Answer / suguk

The are three types Replication are
*Unidirectional*Bidirectional*Peer-Peer
*unidirectionalReplication
Transactions that occur at a source table are replicated
over WebSphere® MQ queues to a target table or are passed
as input parameters to a stored procedure to manipulate the
data.
Transactions that occur at the target table are not
replicated back to the source table.
The target table typically is read only or is not updated
by applications other than the Q Apply program.
*Bidirectional
Number of replication queue maps
Between each pair of servers that participate in
bidirectional replication, you need two replication queue
maps. For example, if you have two servers named SERVER_RED
and SERVER_GREEN, you need two replication queue maps:
One to identify the WebSphere® MQ queues that transport
data from SERVER_RED to SERVER_GREEN
One to identify the WebSphere MQ queues that transport data
from SERVER_GREEN to SERVER_RED
Number of Q subscriptions
For every logical table that is replicated in bidirectional
replication, you need a pair of Q subscriptions between the
two servers. For example, if you have two servers named
SERVER_RED and SERVER_GREEN, then two Q subscriptions are
built for you:
One from the source table on SERVER_RED to the target table
on SERVER_GREEN
One from the source table on SERVER_GREEN to the target
table SERVER_RED.
*Peer-peer
Peer-to-Peer applications are defined as programs which
allow computers to share data in the form of music, movies,
games or any computer file or software over a local network
and the Internet. Fordham University does not, at this
time, prohibit and does not block the use of peer-to-peer
applications on any part of its network. The University
understands that there are legitimate academic uses for
such applications. However, use of these applications has
been known to cause problems, which can affect the entire
University community.

Explain partitioned view?

0 Answers  

---

What are sp_configure commands and set commands?

0 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

Why transaction is important?

0 Answers  

---

Can you explain various data region available in ssrs with their use?

0 Answers  

---

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

how do u find least salary in a table

4 Answers  

---

* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2

0 Answers  

---

What is the user of Primary key?

0 Answers  

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---