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?
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 the purpose of the model database?
What is a trigger? Why we need it?
Is INSTEAD OF trigger directly applicable to Table ?
what information is maintained within the msdb database? : Sql server administration
How use inner join in sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are “phantom rows”?
How you can change the database name in SQL SERVER?
Where views are stored in sql server?
What is a view in sql?
What are different types of statements that are supported by sql?
What is transaction server explicit transaction?
What are the differences between having and where clause.
What is the parse query button used for?
What is Service Broker in sql server 2012?