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
How to create a large table with random data for index testing in ms sql server?
Explain Capacity planning to create a database? and how to monitor it?
What is mapping schema?
What are the instances when triggers are appropriate?
What is the full form of dql?
What is deploy, process and build? : sql server analysis services, ssas
Does partitioning help performance?
Is sql server implemented as a service or an application? : Sql server database administration
What are the aggregate and scalar functions?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What are the types of indexing?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the federation in sql azure?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are the components of dbms?