1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication?
- 7 Answers
- 11492 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / hari
DBMS : Collection of data in Database
RDBMS : Collection of releated data in a database.
In Trancation Replication : Initial snapahot of the data is
applied to at subscribers. and then when data modifications
are made at the publisher , the individual transcation are
captured and propogated to sbuscribers
In Merge replication : is the process of distributing data
from publisher to subscriber, allowing the publisher and
subscribers to make updates while connected or disconnected
and then merging the updates between sites when they are
connencted
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is merge?
What is filter index?
What are the two modes of authentication in sql server?
What is the need for indexing?
How to write a query with a right outer join in ms sql server?
How to update muliple row in single query?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is clustered vs nonclustered index?
What are joins in sql and what are the different types of joins?
What is trace flag in sql server?
Give me any three differences between Truncate and Delete.
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
How to create a view with data from multiple tables?
What is #table in sql server?
