Answer / 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)

How to make a replica of existing oracle server to another server?

3 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---