What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer Posted / kishor
move/copy of the data from one server to another server is
call replication
types of replication
1.snapshot
2.merge
3.transactional
4.transactional with up-datable subscription(newly added in
sql server2005)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What authentication modes does sql server support? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the role of dip user in our database?
What are the commands you'd issue to show the explain plan for "select * from dual"?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Where would you look for errors from the database engine?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you initialize log miner?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What the different components in replication and what is their use? : sql server DBA