InterviewUp – Job Interview Questions and Answers – What is database replicaion? What are the...

March 19, 2010

Home

Sign-In

My Interview Questions

InterviewUp is actively seeking partnerships. Inquire at business@interviewup.com

Question & Additional Information

244

UPs

What is database replicaion? What are the different types of replication you can set up in SQL Server?

Comments (0) |

Inappropriate

Asked By: Anonymous

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

Replication is a method of copying data from one database to other database or one server to another .
We have different types replications.
Transactional , Snapshot , Merge , Logshipping and in 2005 one more type is introducde which was called as peer to peer replications.
Transactional Replication In transactional replication data is copied first time as in snapshot replication , but later only the transactions are synchronized rather than replicating the whole database.You can either specify to run continuously or on periodic basis.
Snapshot Replication takes snapshot of one database and moves it to the other database.After initial load data can be refreshed periodically.The only disadvantage of this type of replication is that all data has to copied
each time the table is refreshed.
Merge replication combines data from multiple sources into a single central database.Again as usual the initial
load is like snapshot but later it allows change of data both on subscriber and publisher , later when they come on-line it detects and combines them and updates accordingly.

Tags

Edit

database, replication

Asked At

Edit

hcl

Job Titles

Edit

database

Comments (0) :

Your Name:

Add your comment text

Tags

finance, Creit risk, Market Risk, Liquidity Risk

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

325

UPs

what tools are used for debugging on unix ?

Add or view comments about this interview question

Comments (1) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

gdb is 1 of the debuggers used in Unix

Create Date

Sunday, January 20, 2008

Tags

database

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

Rachit

Saturday, July 04, 2009 1:57 PM

gdb is 1 of the debuggers used in Unix

See all 1 comments

294

UPs

What is LINQ in .NET 3.0?

Comments (0) |

Inappropriate

Asked By: vihar |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

LINQ defines standard query operators that allow code written in LINQ-enabled languages to filter, enumerate, and create projections of several types of collections using the same syntax. Such collections may include arrays, enumerable classes, XML, datasets from relational databases, and third party data sources. The LINQ project uses features of version 2.0 of the .NET Framework, new LINQ-related assemblies, and extensions to the C# and Visual Basic .NET languages. Microsoft has distributed a preview release of LINQ, consisting of those libraries and compilers for C# 3.0 and Visual Basic 9. Other languages, such as F# and Nemerle, have also announced preliminary support.

Create Date

Friday, October 19, 2007

Tags

ORM, data access

Asked At

None

Job Positions

devloper

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

224

UPs

What does T mean in 100BaseT

Comments (0) |

Inappropriate

Asked By: Marlon29 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

T means twisted pair cable. There are two types of cable STP (Shielded Twisted Pair Cable) and UTP (Unshielded Twisted Pair Cable). 100BaseT uses category 5, 5e, 6 twisted cable that is connected to RJ45.

Create Date

Friday, March 28, 2008

Tags

network, networking, cabling, twisted pair, connectors

Asked At

None

Job Positions

Network Technician

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

146

UPs

What is a typical work week in your mind?

Comments (0) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

I am a college student who goes to school full time and need a part time job and want to work as a server at a restaurant and was told to prepare for this question and dont know how to answer

Create Date

Wednesday, February 11, 2009

Tags

None

Asked At

None

Job Positions

Server restaurant Support

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

242

UPs