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 a self join? Explain it with an example? : Sql server database administration
What are the advantages of using a stored procedure?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Does index slows down insert statements?
Can a table be moved to different filegroup?
What is bulkcopy in sql?
How can you manage sql azure security?
Difference between uniqe index and uniqe constraint?
What are the advantages of paper records?
What is bookmark link in ssrs?
What is scrollable cursor?
How to use copy and concatenate commands in SQL?
What are the different types of normalization?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What are the rules to use the rowguidcol property to define a globally unique identifier column?